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