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

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

日期的定义方法是year（date)=2021 and month(date)=8

数据去重 distinct