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

select vip,sum(cv) visit_nums,
    count(t1.user_id) visit_users      --再求不同vip等级的所有用户人数和所有用户访问次数之和
	from (
		select user_id ,count(visit_time) cv    --先求出每个用户的访问次数
		from visit_tb 
		group by user_id) t1
	join 
	uservip_tb  b
	on t1.user_id = b.user_id
group by vip
order by visit_nums desc,vip asc