题解 | 更新用户积分信息？
更新用户积分信息？
https://www.nowcoder.com/practice/ef1f2fda4338460b948810f3f7e7a68e
select
t2.user_id,
point+points as point
from
uservip_tb t1
right join
(select
user_id,
sum(order_price) points
from
order_tb
where
order_price>100
group by
user_id
) t2
on
t1.user_id=t2.user_id
order by
point desc
查看9道真题和解析
