可口可乐产品条形码

select item_code,barcode from item where description like '%可口可乐%'

;select sum(sales_value)salevalue,sum(sales_unit) saleslfrom sales where to_char(period,'yyyymm')='200907' order by 1