select round(sum(sales_price)/sum(tag_price*sales_num)*100, 2) as 'discount_rate(%)'
from (
    select a.item_id, a.tag_price, b.sales_num, b.sales_price
    from product_tb as a
    left join sales_tb as b
    on a.item_id = b.item_id
) as c;