题解 | 查询单日多次下订单的用户信息？

select
    date_format (order_time, '%Y-%m-%d') as order_date,
    o.user_id as user_id,
    count(order_id) as order_nums,
    u.vip as vip
from
    order_tb o,
    uservip_tb u
where
    o.user_id = u.user_id
group by
    o.user_id,
    order_date
having
    order_nums > 1
order by
    order_nums desc