# 首先知道折扣率是指，销售总价/gmv总额
select round(sum(sales_price)/sum(sales_num*tag_price)*100,2) `discount_rate(%)`
from sales_tb s 
join product_tb p
on s.item_id = p.item_id