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 2 desc,1;

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 2 desc,1;