题解 | 统计各等级会员用户下订单总额
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
相关推荐
小浪_Coding:你问别人,本来就是有求于人,别人肯定没有义务免费回答你丫, 有点流量每天私信可能都十几,几十条的,大家都有工作和自己的事情, 付费也是正常的, 就像你请别人搭把手, 总得给人家买瓶水喝吧