SELECT
    DAY (date) AS day,
    COUNT(*) AS question_cnt
FROM
    question_practice_detail
WHERE
    MONTH (date) = '08'
group by
    day