# 先得到每款商品的销售数目和销售总金额
with a as(
    select
        style_id,
        sum(inventory) as kucun,
        sum(tag_price*inventory) as beihuo
    from 
        product_tb
    group by 
        style_id
),
b as(
    select
        p.style_id,
        sum(sales_num) as shouchu,
        sum(sales_price) as gvm
    from 
        sales_tb as s
        left join product_tb as p on s.item_id=p.item_id
    group by 
        p.style_id
)
select  
    a.style_id,
    round(100*b.shouchu/(a.kucun-b.shouchu),2) as pin_rate,
    round(b.gvm*100/a.beihuo,2)
from 
    a left join b on a.style_id=b.style_id