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