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

select
    count(distinct device_id) did_cnt, 
    count(question_id) question_cut
from 
    question_practice_detail
where
    DATE_FORMAT(date, '%Y-%m') = DATE_FORMAT("2021-08-01", '%Y-%m');