select
    day (date),
    count(question_id) as question_cnt
from
    question_practice_detail
where
    MONTH (date) = 8
group by
    day (date)