题解 | 更新用户积分信息？
更新用户积分信息？
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
投递牛客等公司7个岗位 >
SHEIN公司福利 517人发布