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