題解 | #計算用戶8月每天的練題數(shù)量#
計算用戶8月每天的練題數(shù)量
http://fangfengwang8.cn/practice/847373e2fe8d47b4a2c294bdb5bda8b6
select
extract(day from date) as day,
count(question_id) as question_cnt
from question_practice_detail
where
extract(year from date)=2021 and
extract(month from date)=8
group by day