题解 | 统计各等级会员用户下订单总额
统计各等级会员用户下订单总额
https://www.nowcoder.com/practice/48dd35a3dd8c4e1494db36b097a03300
SELECT vip, SUM(order_price) order_total FROM( SELECT u.user_id, vip, order_id, CASE WHEN order_price IS NULL THEN 0 ELSE order_price END order_price FROM uservip_tb u LEFT JOIN order_tb o ON u.user_id = o.user_id ) sub GROUP BY vip ORDER BY order_total DESC
查看8道真题和解析