题解 | #某宝店铺折扣率#

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