SELECT day(date) day,count(1) question_cnt from question_practice_detail where year(date)=2021 and month(date)=8 group by day(date)

需求分析:求日期及该日期下联系的题目数量

熟练使用day,month,year函数