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

with t1 as (
    select 
        date(order_time) as order_date,
        user_id,
        count(*) as order_nums
    from order_tb
    group by date(order_time), user_id
    having count(*) > 1  -- 单日下单多次
)
select 
    t1.order_date,
    t1.user_id,
    t1.order_nums,
    u.vip
from t1
left join uservip_tb u on t1.user_id = u.user_id
order by t1.order_nums desc;