select count(distinct device_id) as did_cnt, count(question_id) as ququestion_cnt
from question_practice_detail
where date like '2021-08%';

注意设备id的去重