题解 | #计算用户8月每天的练题数量#

select  day(date) day, count(question_id) question_cnt
from question_practice_detail
where month(date)='08' and year(date)='2021'
group by date;