题解 | #计算用户8月每天的练题数量#
计算用户8月每天的练题数量
https://www.nowcoder.com/practice/847373e2fe8d47b4a2c294bdb5bda8b6
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;
题解: DAY(date) as day DAY()函数取日期的 2021-08-13 天(13)
条件也可以用模糊查询 date like %2021-08%
然后对day进行分组
查看20道真题和解析