select
    count(distinct device_id) as did_cnt,
    count(question_id) as question_cnt
from
    question_practice_detail
where
    year (`date`) = '2021'
    and month (`date`) = '8'

唯一值得注意的一点是不要重复统计做过题的用户