select 
    day(date) as day,//取日期中的日
    count(question_id) as question_cnt//统计题数
from question_practice_detail
where year(date) = 2021 and month(date) = 8 //2021年8月
group by day;//根据日分组