with
    t as (
        select distinct
            date (order_time) as order_date,
            user_id,
            count(order_id) over (
                partition by
                    date (order_time),
                    user_id
            ) as order_nums,
            vip
        from
            order_tb
            left join uservip_tb using (user_id)
    )
select
    t.*
from
    t
where
    order_nums > 1
order by
    order_nums desc