题解 | #每月及截止当月的答题情况#
每月及截止当月的答题情况
https://www.nowcoder.com/practice/1ce93d5cec5c4243930fc5e8efaaca1e
select start_month, count(distinct uid) mau, sum(new_day) month_add_uv, max(sum(new_day))over(order by start_month) max_month_add_uv, sum(sum(new_day))over(order by start_month) cum_sum_uv from (select *,date_format(start_time,'%Y%m') start_month, if(start_time=min(start_time)over(partition by uid),1,0) new_day from exam_record ) t1 group by start_month
查看1道真题和解析