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
比较简单