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

select 
    count(distinct device_id) did_cnt,
    count(*) question_cnt
from 
    question_practice_detail t1
where 
    month(t1.date) = 8
    and year(t1.date) = 2021