#查询出每个行业的总销售额。查询结果按照行业总销售额降序排列，如果销售金额一致按照行业名称升序排列
select industry,sum(sale_amount) as total_sales_amount
from merchants_underline as a
inner join sales_underline as b
on a.merchant_id = b.merchant_id
group by industry
order by total_sales_amount desc,industry