select day, count(day) "question_cnt"
FROM
    (select DAYOFMONTH(DATE) "day",MONTH(DATE) "mon"
    from question_practice_detail
    where MONTH(DATE) = 8) t
group by DAY
还是挺简单的