select  
    day(t1.date) day,
    count(*) question_cnt
from 
    question_practice_detail t1
where 
    t1.date >= '2021-08-01' 
    and t1.date <= '2021-8-31'
group by
    day