题解 | #平均活跃天数和月活人数#
平均活跃天数和月活人数
https://www.nowcoder.com/practice/9e2fb674b58b4f60ac765b7a37dde1b9
这个比较好看。 select date_format(start_time,"%Y%m"), round( count(distinct date(submit_time),uid)/count(distinct case when score is not null then uid end),2) as avg_active_days , count(distinct case when score is not null then uid end) from exam_record where year(start_time)=2021 group by date_format(start_time,"%Y%m")
投递速腾聚创等公司10个岗位 >
