题解 | 更新用户积分信息?
select
o.user_id as user_id,
u.point + sum(o.order_price) as point
from
order_tb o,
uservip_tb u
where
o.user_id = u.user_id
and o.order_price > 100
group by
o.user_id
order by
point desc
select
o.user_id as user_id,
u.point + sum(o.order_price) as point
from
order_tb o,
uservip_tb u
where
o.user_id = u.user_id
and o.order_price > 100
group by
o.user_id
order by
point desc
相关推荐