select day(date) as day,count(1) question_cnt
from question_practice_detail
where date >= '2021-08-01' and date < '2021-09-01'
group by day