SELECT
    day(date) day,
    count(question_id) question_cnt
FROM question_practice_detail
WHERE YEAR(date) = 2021 and MONTH(date) = 8
GROUP BY date;