SELECT
    DAY(DATE) day,
    COUNT(question_id) question_cnt
FROM
    question_practice_detail
WHERE
    YEAR(DATE) = 2021 AND
    MONTH(DATE) = 8
GROUP BY
    DATE;