select date_format(submit_time, '%Y%m') as month, round(count(distinct uid, date_format(start_time,"%Y%m%d"))/count(distinct uid),2), count(distinct uid) as mau from exam_record where YEAR(submit_time)= '2021' group by 1 公众号:鲸析小红书:鲸鲸说数据思路首先,本题目搞清楚两个指标的计算逻辑,也就是含义,很多同学没捋清楚上来就做,效率就比较低。限制条件(...