题解 | 统计各等级会员用户下订单总额
select
u.vip as vip,
sum(if(v.order_price is null,0,v.order_price)) as order_total
from
order_tb v right join
uservip_tb u
on
v.user_id = u.user_id
group by
u.vip
order by
order_total desc
select
u.vip as vip,
sum(if(v.order_price is null,0,v.order_price)) as order_total
from
order_tb v right join
uservip_tb u
on
v.user_id = u.user_id
group by
u.vip
order by
order_total desc
相关推荐