tag_price只是单价要记得乘数量

select round(sum(s.sales_price)*100/sum(s.sales_num*p.tag_price),2) as 'discount_rate(%)'
from sales_tb s left outer join product_tb p
    on s.item_id=p.item_id