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

with
t1 as(
    select
        user_id,
        date_format(order_time,'%Y-%m-%d') as order_date,
        count(user_id) as cnt
    from
        order_tb
    group by
        order_date,
        user_id
)
,t2 as(
    select
        order_date,
        user_id,
        cnt as order_nums,
        vip
    from
        t1 left join uservip_tb using(user_id)
    where
        cnt>=2
    order by
        order_date,
        order_nums
)

select * from t2