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

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