select industry,sum(sale_amount) 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