with

    t1 as (

        select

            user_id,

            sum(if (order_price > 100, order_price, 0)) as point

        from

            order_tb

        group by

            user_id

    )

select

    t1.user_id,

    ut.point + t1.point as point

from

    t1

    left join uservip_tb ut using (user_id)

where

    t1.user_id = ut.user_id

order by

    point desc