题解 | #平均活跃天数和月活人数#
平均活跃天数和月活人数
https://www.nowcoder.com/practice/9e2fb674b58b4f60ac765b7a37dde1b9
select date_s,round(count(distinct uid,date_v)/count(distinct uid),2),count(distinct uid) st from (select uid,date_format(submit_time,"%Y%m%d") date_v,date_format(submit_time,"%Y%m") date_s,(submit_time-start_time) num from exam_record where score>0 and date_format(submit_time,"%Y")="2021" ) t group by date_s

文远知行公司福利 583人发布