select day(date) day, count(*) question_cnt from question_practice_detail group by date having month(date)=8