题解 | #平均活跃天数和月活人数#
平均活跃天数和月活人数
https://www.nowcoder.com/practice/9e2fb674b58b4f60ac765b7a37dde1b9
SELECT DATE_FORMAT(start_time,'%Y%m') AS `month`, ROUND( COUNT(DATE_FORMAT(start_time,'%Y%m%d')) / COUNT(DISTINCT uid),2) AS avg_active_days , COUNT(DISTINCT uid) AS mau FROM exam_record WHERE start_time LIKE '2021%' && submit_time IS NOT NULL GROUP BY `month`;
投递安克创新 Anker等公司10个岗位
