select date_format(date,'%d')  day  , count(*) question_cnt from question_practice_detail 
where date_format(date,'%m')=08
group by day