select
    count(distinct device_id) as did_cnt,
    count(*) as question_cnt
from
    question_practice_detail
where
    substring(date,1,7)='2021-08'