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

SELECT 
    t.order_date,
    t.user_id,
    t.order_nums,
    u.vip
FROM (
    SELECT 
        DATE(o1.order_time) AS order_date,
        o1.user_id,
        COUNT(DISTINCT o1.order_id) AS order_nums
    FROM order_tb o1 JOIN order_tb o2
    ON DATE(o1.order_time) = DATE(o2.order_time) AND o1.user_id = o2.user_id AND o1.order_id <> o2.order_id
    GROUP BY order_date, o1.user_id ) t JOIN uservip_tb u ON t.user_id = u.user_id
ORDER BY order_nums DESC