题解 | 统计各等级会员用户下订单总额
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
相关推荐