题解 | 统计各等级会员用户下订单总额
SELECT
vip,
if(sum(order_price)>0,sum(order_price),0) order_total
FROM order_tb
RIGHT JOIN uservip_tb USING(user_id)
GROUP BY vip
ORDER BY order_total DESC
SELECT
vip,
if(sum(order_price)>0,sum(order_price),0) order_total
FROM order_tb
RIGHT JOIN uservip_tb USING(user_id)
GROUP BY vip
ORDER BY order_total DESC
相关推荐