select round(sum(sales_price)/sum(tag_price*sales_num)*100,2) "discount_rate(%)" from
product_tb left join sales_tb using(item_id)

折扣率=GMV/（吊牌金额*销售量）=SUM(sales_price)/SUM(sales_num*tag_price)