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

# select 
#     day(date) as day,
#     count(question_id) as question_cnt
# from question_practice_detail
# where 
#     date like '2021-08%'
# group by
#     day(date);


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(date);