select day(date) as day,
       count(result) as question_cnt
from question_practice_detail
group by date
having date_format(date, "%Y-%m")="2021-08"


select day(date) as day,
       count(result) as question_cnt
from question_practice_detail
group by date
having year(date)=2021 and month(date)=8