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

select
    order_date,
    t.user_id,
    order_nums,
    vip
from
    (
        select
            user_id,
            date_format(order_time, "%Y-%m-%d") as order_date,
            count(*) as order_nums
        from
            order_tb
        group by
            user_id,
            date_format(order_time, "%Y-%m-%d")
        having
            order_nums > 1
    ) as t
    inner join uservip_tb ut on t.user_id = ut.user_id
order by
    order_nums desc