select day(date) as day,count(*) as question_cnt
from question_practice_detail
where year(date)=2021 and month(date)=8
group by day(date)

没有用其他的函数，只用了日期相关的函数