select substr(t1.item_id,1,1) style_id, round(sum(t1.total_sale) / sum(t2.total_invent - t1.total_sale ) * 100, 2), round(sum(t1.sale_price) / sum(t2.total_price) * 100, 2) from (select s.item_id , sum(s.sales_num) total_sale, sum(s.sales_price) sale_price from sales_tb s group by s.item_id) as t1 l...