题解 | #平均活跃天数和月活人数#
平均活跃天数和月活人数
https://www.nowcoder.com/practice/9e2fb674b58b4f60ac765b7a37dde1b9
select
DATE_FORMAT(day,'%Y%m') month,
FORMAT(count(uid)/count(distinct uid),2) avg_active_days,
count(distinct uid) mau
from (
select
distinct uid,DATE_FORMAT(start_time,'%Y%m%d') day
from exam_record
where DATE_FORMAT(start_time,'%Y')='2021'
and submit_time is not null
group by uid,DATE_FORMAT(start_time,'%Y%m%d')
) a
group by DATE_FORMAT(day,'%Y%m')
投递阿里巴巴等公司9个岗位
