题解 | 电商平台需要对各行业销售情况综合评估
电商平台需要对各行业销售情况综合评估
https://www.nowcoder.com/practice/120cbc6f87214886bbba80d2b5414786
select industry,sum(sale_amount) total_sales_amount from ( select industry ,sale_amount from merchants_underline m left join sales_underline s on m.merchant_id = s.merchant_id )a group by 1 order by 2 desc