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