select substring(date,9,2) as day, count(*) as question_cnt from question_practice_detail where date>="2021-08-01" and date<="2021-08-31" group by date