select industry, sum(sale_amount) as total_sales_amount
from sales_underline
join merchants_underline using(merchant_id)
group by industry
order by total_sales_amount desc,industry;