select dayofmonth(date) as day, count(question_id) as question_cnt

from question_practice_detail
where year(date) = 2021 and month(date)=8
group by day

取年是year()

取月是month()

取日是dayofmonth()