题解 | #计算用户8月每天的练题数量#
计算用户8月每天的练题数量
https://www.nowcoder.com/practice/847373e2fe8d47b4a2c294bdb5bda8b6
select day(qpd.date) day, count(*) question_cnt from question_practice_detail qpd where qpd.date >= '2021-08-01' and qpd.date <= '2021-08-31' group by qpd.date
一个注意点,取日期的方法,day(date),month(date),year(date)分别可以取出日月年,用date_format函数的date_format(date, "%Y-%m")="202108"