题解 | 统计各等级会员用户下订单总额
SELECT
ut.vip,
IFNULL(SUM(ot.order_price),0) order_total
FROM uservip_tb ut
LEFT JOIN order_tb ot ON ut.user_id = ot.user_id
GROUP BY ut.vip
ORDER BY order_total DESC
SELECT
ut.vip,
IFNULL(SUM(ot.order_price),0) order_total
FROM uservip_tb ut
LEFT JOIN order_tb ot ON ut.user_id = ot.user_id
GROUP BY ut.vip
ORDER BY order_total DESC
相关推荐