题解 | 统计商家不同会员每日访问人次及访问人数
统计商家不同会员每日访问人次及访问人数
https://www.nowcoder.com/practice/0017dc22426b495889da3304dcf254d1
with t1 as (
select v.user_id,date(visit_time) as visit_date, vip
from visit_tb v
left join uservip_tb u on u.user_id = v.user_id
)
# id, visit day, vip
select
vip,
count(visit_date) as visit_nums ,
count(distinct user_id) as visit_users
from t1
group by vip
order by 2 desc,3 desc
查看18道真题和解析