select substr(date, 9, 2) day, count(*) question_cnt
from question_practice_detail
where date like '2021-08%' 
group by date;