with a as(
    select user_id,
        date(order_time) as order_date,
        count(*) as order_nums
    from order_tb
    group by user_id,date(order_time)
    having count(*)>1
)
select order_date,
    a.user_id,
    order_nums,
    vip
from a join uservip_tb using(user_id)
order by order_nums desc;