select 
count(distinct(device_id)) did_cnt,
count(result) question_cnt
from question_practice_detail
where month(`date`) = '08'
group by month (`date`)

分组查询统计用户数和答题总数