select industry,sum(sale_amount) total_sales_amount
from (
select industry
,sale_amount
from merchants_underline m
left join sales_underline s
on m.merchant_id  = s.merchant_id 
)a
group by 1
order by 2 desc