题解 | #平均活跃天数和月活人数#
平均活跃天数和月活人数
https://www.nowcoder.com/practice/9e2fb674b58b4f60ac765b7a37dde1b9
select
concat (
year (submit_time),
if (
month (submit_time) < 10,
concat ('0', month (submit_time)),
submit_time
)
) `month`,
round(count(DISTINCT uid,date(submit_time)) / count(DISTINCT uid), 2) avg_active_days,
count(DISTINCT uid) mau
from
exam_record
where
submit_time is not null
and year (submit_time) = 2021
group by
month
投递字节跳动等公司7个岗位 >
