#生成一行sales_price/sales_num as sales_jiage
#avg(sales_jiage) group by item_id
#两表连接

select round(sum(sales_price)/sum(tag_price*sales_num)*100,2) as discount_rate

from sales_tb s
join product_tb p
on s.item_id = p.item_id