select day(date) as day,count(id) as question_cnt from question_practice_detail where month(date) = 8 group by day;