题解 | 电商平台需要对各行业销售情况综合评估
电商平台需要对各行业销售情况综合评估
https://www.nowcoder.com/practice/120cbc6f87214886bbba80d2b5414786
# 查询出每个行业的总销售额
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
