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

select
    EXTRACT(
        DAY
        FROM
            question_practice_detail.date
    ) AS day,
    count(question_id) as question_cnt 
from
    question_practice_detail
where
    question_practice_detail.date like ("2021-08%")
group by
    question_practice_detail.date;