题解 | 电商平台需要对各行业销售情况综合评估
电商平台需要对各行业销售情况综合评估
https://www.nowcoder.com/practice/120cbc6f87214886bbba80d2b5414786
select
industry,
sum(sale_amount) as total_sales_amount
from
merchants_underline as m
inner join sales_underline as s on m.merchant_id = s.merchant_id
group by
industry
order by
total_sales_amount desc,
industry asc;
查看10道真题和解析