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