题解 | 更新用户积分信息?
select o.user_id,(point+sum(order_price)) point from order_tb o join uservip_tb u on o.user_id = u.user_id where order_price>100 group by o.user_id order by point desc
select o.user_id,(point+sum(order_price)) point from order_tb o join uservip_tb u on o.user_id = u.user_id where order_price>100 group by o.user_id order by point desc
相关推荐