题解 | 查询下订单用户访问次数？

SELECT
    user_id ,COUNT(user_id) as visit_nums
FROM
    (
        SELECT
            vt.user_id as user_id,
            vt.visit_time as visit_time
        FROM
            order_tb as ot
            LEFT JOIN visit_tb as vt ON ot.user_id = vt.user_id
        WHERE
            DAY (ot.order_time) = '2'
            AND DAY (visit_time) = '2'
        GROUP BY
            user_id,
            visit_time
    ) as re
GROUP BY user_id
ORDER BY visit_nums DESC