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