题解 | 统计各等级会员用户下订单总额
select vip, if(sum(order_sum) >0,sum(order_sum) ,0)order_total from( select o.user_id, vip, sum(order_price) order_sum from uservip_tb u left join order_tb o on o.user_id =u.user_id group by o.user_id,vip ) t group by vip order by order_total desc
