# 连接两个子查询表,并选取合适字段按题目要求计算值 select k1.style_id, round(ifnull(sku_saled_num,0)/(inventory_num-ifnull(sku_saled_num,0))*100,2) `pin_rate(%)`, round(gmv/beihuo*100,2) `sell-through_rate(%)` from ( # 先根据产品表取出各个款号的库存数目及备货值 select style_id, sum(inventory) inventory_num, sum(tag_price*inventory) bei...