题解 | 更新用户积分信息？
更新用户积分信息？
https://www.nowcoder.com/practice/ef1f2fda4338460b948810f3f7e7a68e
with point_update as(
select user_id,
sum(order_price) as update_point
from order_tb
where order_price > 100
group by user_id
)
select p.user_id as user_id,
(p.update_point + u.point) as point
from point_update as p
left join uservip_tb as u on p.user_id = u.user_id
order by point desc
#第一次尝试建立新的表格，用from同样可以
查看16道真题和解析