题解 | 统计商家不同会员每日访问人次及访问人数
统计商家不同会员每日访问人次及访问人数
https://www.nowcoder.com/practice/0017dc22426b495889da3304dcf254d1
select t2.vip ,count(t1.user_id) visit_nums ,count(distinct t1.user_id) visit_users from visit_tb t1 join uservip_tb t2 on t1.user_id = t2.user_id group by 1 order by 2 desc
查看6道真题和解析