SELECT a.style_id, #动销率=以及卖出的/现有库存 ROUND(b.sales_num_total/(a.inventory_total-b.sales_num_total)*100,2) AS pin_rate, #售罄率=GMV/备货值,备货值=吊牌价*库存数 ROUND(b.GMV/a.inventory_price*100,2)AS sell_through_rate FROM #将生成的两个子表在进行联结查询,把相应的值进行计算 (#在product_tb计算出商品库存量、备货值 SELECT style_id, SUM(inve...