题解 | 统计商家不同会员每日访问人次及访问人数
SELECT vip, count(user_id) visit_nums, count(DISTINCT user_id) visit_users FROM visit_tb JOIN uservip_tb USING(user_id) GROUP BY vip ORDER BY visit_nums DESC
SELECT vip, count(user_id) visit_nums, count(DISTINCT user_id) visit_users FROM visit_tb JOIN uservip_tb USING(user_id) GROUP BY vip ORDER BY visit_nums DESC
相关推荐