题解 | 统计各等级会员用户下订单总额

select
    a.vip vip,
    sum(判断) order_total
from
    (
        select
            vip,
            if (order_price is null, 0, order_price) 判断
        from
            test.uservip_tb ut
            left join test.order_tb ot on ut.user_id = ot.user_id
    ) a
group by
    a.vip
order by
    order_total desc