题解 | 统计各等级会员用户下订单总额
统计各等级会员用户下订单总额
https://www.nowcoder.com/practice/48dd35a3dd8c4e1494db36b097a03300
要点 coalesce 可以用于替代null值的情况
select u.vip
, coalesce(sum(o.order_price), 0) as order_total
from uservip_tb u
left join order_tb o
on u.user_id = o.user_id
group by u.vip
order by order_total desc
查看30道真题和解析
