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