select DAY(date) as day,count(question_id) as question_cnt 
from question_practice_detail
where MONTH(date) = 08
group by day