【大厂真题】SQL13题解 | 统计各等级会员用户下订单总额
# 对于空的处理
# 排序通过结果要看
# 主表为空数值
SELECT b.vip,COALESCE(SUM(a.order_price),0) AS order_total
FROM uservip_tb b
left join
order_tb a
on b.user_id=a.user_id
GROUP BY b.vip
order by order_total desc
查看15道真题和解析