题解 | 更新用户积分信息？
更新用户积分信息？
https://www.nowcoder.com/practice/ef1f2fda4338460b948810f3f7e7a68e
with t as(
select
user_id,
sum(order_price) as total_p
from order_tb
where order_price > 100
group by user_id
)
select
u.user_id,
u.point + total_p as point
from uservip_tb u
inner join t
on u.user_id = t.user_id
order by u.point + total_p desc;
