题解 | #月总刷题数和日均刷题数#

3个知识点： 1.天数的获得 day()与last_day结合使用 2.记得取余数round() 3.列数相同的的结果拼接 union all 4.对于出现的only_full_group_by 问题，加上any_value即可

count(submit_time) as month_q_cnt,
round(count(submit_time)/any_value(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 all 

select '2021汇总' as submit_month,count(submit_time) as month_q_cnt,
round(count(submit_time)/31,3)
from practice_record
where year(submit_time)='2021'
order by submit_month