题解 | #某宝店铺动销率与售罄率#
某宝店铺动销率与售罄率
https://www.nowcoder.com/practice/715dd44c994f45cb871afa98f1b77538
误区:
1.有销售的SKU数量:是销售的所有商品数量,即sum(sales_num),而不是count(distinct item_id)
2.在售SKU数量:备货数量-销售数量,即sum(inventory)-sum(sales_num),而不是count(distinct product_tb.item_id)
with t1 as( select item_id, sum(sales_num) as num, sum(sales_price) as item_GMV from sales_tb group by item_id ) select style_id, round(100*sum(num)/(sum(inventory)-sum(num)),2) as 'pin_rate(%)', round(100*sum(item_GMV)/sum(inventory*tag_price),2) as 'sell-through_rate(%)' from product_tb left join t1 using(item_id) group by style_id order by style_id