题解 | 统计各等级会员用户下订单总额
统计各等级会员用户下订单总额
https://www.nowcoder.com/practice/48dd35a3dd8c4e1494db36b097a03300
select u.vip, COALESCE(sum(o.order_price),0) as order_total from order_tb o right join uservip_tb u on o.user_id = u.user_id group by u.vip order by order_total desc
COALESCE(字段,0)确保不出现null值,若出现会用0代替