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

要求

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

思路

1. 8月：EXTRACT(Month from date) = 08
2. 每天： Distinct EXTRACT(DAY from date)
3. 练题数量：count(result)

实现

SELECT DISTINCT EXTRACT(DAY from date) AS day, COUNT(result) as question_cnt 
FROM question_practice_detail
WHERE EXTRACT(MONTH from date) = 08 
GROUP BY day