# 查询出每个行业的总销售额
with
t1 as(
    select
        industry,
        sum(sale_amount) as total_sales_amount
    from
        sales_underline left join merchants_underline using(merchant_id)
    group by
        industry
    order by
        total_sales_amount desc,
        industry
)

select * from t1