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