select day,count(question_id) as question_cnt
from
-- 创建子查询
(
    select *,
	month(date) as month,
	day(date) as day
from question_practice_detail
) as a
where month=8
group by day;