I have a table of sales
我有一张销售表
SALE_ID | Product_Code | Qty | Sales_Value | Taxes ....
==========+===================+========+===============+=========
001 | AAAA | 1 | 1000 | 50 ....
001 | BBBB | 1 | 10 | 0.5
002 | CCCC | 1 | 30 | 1.5
002 | AAAA | 1 | 1000 | 1.5
SALE_ID |