题解 | 统计商家不同会员每日访问人次及访问人数

SELECT
    b.vip,
    COUNT(*) AS visit_nums,
    COUNT(DISTINCT a.user_id) AS visit_users
FROM visit_tb AS a
INNER JOIN uservip_tb AS b
    ON (a.user_id = b.user_id)
GROUP BY b.vip
ORDER BY visit_nums DESC;