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

select
    a.日期 order_date,
    user_id,
    a.次数 order_nums,
    vip
from
    (
        select
            ot.user_id,
            date (order_time) 日期,
            vip,
            count(*) 次数
        from
            test.order_tb ot
            join test.uservip_tb ust on ot.user_id = ust.user_id
        group by
            ot.user_id,
            date (order_time),
            vip
    ) a
where
    次数 > 1