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同样可以