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

SELECT day(date) AS day,count(question_id) AS question_cnt
FROM question_practice_detail
WHERE year(date)=2021 and month(date)=08
GROUP BY day

记录一下日期函数year(),month(),day()