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