知识点：group by substr count
select SUBSTR(date,9,10) as day,
count(question_id) as question_cnt
from question_practice_detail
where SUBSTR(date,1,7)='2021-08'
group by SUBSTR(date,9,10)
;