题解 | 统计各等级会员用户下订单总额
统计各等级会员用户下订单总额
https://www.nowcoder.com/practice/48dd35a3dd8c4e1494db36b097a03300
SELECT DISTINCT vip, COALESCE(SUM(order_price), 0) AS order_total FROM uservip_tb LEFT JOIN order_tb USING(user_id) GROUP BY vip ORDER BY order_total DESC;
查看24道真题和解析