题解 | #某宝店铺动销率与售罄率#

select 
    p.style_id,
    round(sum(sales_num)/(sum(inventory)-sum(sales_num))*100,2) as pin_rate,
    round(sum(s.sales_price)/sum(p.tag_price*p.inventory)*100,2) as sellthrough_rate
from product_tb p join (select item_id,sum(sales_num) as sales_num,
    sum(sales_price) as sales_price from sales_tb
    group by item_id) s on s.item_id = p.item_id group by p.style_id order by style_id;

主要是对两个指标的理解 这部分确实很难懂 感觉涉及到业务方面的知识点了