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