题解 | 更新用户积分信息?
更新用户积分信息?
https://www.nowcoder.com/practice/ef1f2fda4338460b948810f3f7e7a68e
select user_id,sum(order_price)+point point from order_tb ot join uservip_tb ut using(user_id) where order_price>100 group by user_id order by point desc
更新用户积分信息?
https://www.nowcoder.com/practice/ef1f2fda4338460b948810f3f7e7a68e
select user_id,sum(order_price)+point point from order_tb ot join uservip_tb ut using(user_id) where order_price>100 group by user_id order by point desc
相关推荐