掌握year(),month(),day(),time()函数

SELECT day(date) as day,COUNT(*) as question_cnt
FROM question_practice_detail
where date between '2021-08-01' and '2021-08-31'
GROUP BY day;