select 
    day(date) as day,
    count(question_id) as question_cnt
from question_practice_detail
where date like '%2021-08%'
group by day;

day(date) 取出 xx号；

date like ‘%xx%’模糊函数；