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