牛客SQL127——月总刷题数和日均刷题数

题目描述
https://www.nowcoder.com/practice/f6b4770f453d4163acc419e3d19e6746

思路：这题小问题很多
因为会出现only group by问题，所以使用any_value
在最后记得加上where score is not null

select date_format(submit_time,'%Y%m') submit_month,
any_value(count(score)) as month_q_cnt,
any_value(round(count(score)/day(last_day(submit_time)),3)) as avg_day_q_cnt
from practice_record
where year(submit_time)=2021
group by date_format(submit_time,'%Y%m')

union

select '2021汇总' as submit_month , 
any_value(count(score)) as month_q_cnt,
any_value(round(count(score)/31,3)) as avg_day_q_cnt
from practice_record 
where score is not null
and year(submit_time)=2021
order by submit_month