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