SELECT EXTRACT(DAY FROM date) AS day,
COUNT(question_id) AS question_cnt
FROM question_practice_detail
WHERE date BETWEEN '2021-08-01' AND '2021-08-31'
GROUP BY day;