题解 | 21年8月份练题总数

select 
    count(distinct device_id) as did_cnt,
    count(question_id) as question_cnt
from question_practice_detail
where date_format(date,"%Y-%m")="2021-08"