题解 | 统计商家不同会员每日访问人次及访问人数
统计商家不同会员每日访问人次及访问人数
https://www.nowcoder.com/practice/0017dc22426b495889da3304dcf254d1
select vip,
count(u.user_id) as visit_nums,
count(distinct u.user_id) as visit_users
from visit_tb v
left join uservip_tb u
using(user_id)
group by vip
order by visit_nums desc

查看10道真题和解析