SELECT day(date) AS day,count(question_id) AS question_cnt
FROM question_practice_detail
WHERE year(date)=2021 and month(date)=08
GROUP BY day

记录一下日期函数year(),month(),day()