题解 | 更新用户积分信息？
更新用户积分信息？
https://www.nowcoder.com/practice/ef1f2fda4338460b948810f3f7e7a68e
with temp as (
select
ot.user_id,
sum(ot.order_price) + ut.point as point
from order_tb ot
inner join uservip_tb ut
on ut.user_id = ot.user_id
where ot.order_price > 100
group by ot.user_id
)
select * from temp
order by point desc
不过你这绩点不考研浪费了吧