select day(date) as day,
count(*) as question_cnt
from question_practice_detail
where date rlike '^[0-9]{4}(-)[0][8](-)'
group by day;