select
    date_format(date, '%d') day
    ,count(*) question_cnt
from question_practice_detail
where date_format(date, '%y-%m') = '21-08'
group by 
day