select 
    day(date) day,
    count(question_id) question_cnt
from question_practice_detail
where month(date) = '08'
group by date