# 这个题目表述有问题，题目要求每日，但是结果又没有每日的？

select u.vip,
       count(v.user_id) as visit_nums,
       count(distinct v.user_id) as visit_users 
from visit_tb v
join uservip_tb u on v.user_id = u.user_id
group by u.vip
order by visit_nums desc