select
count(distinct device_id) as did_cnt,//总用户数:用户可以登录多次同一台设备
count(question_id) as question_cnt//总次数
from question_practice_detail qpd
where year(date) = 2021 and month(date) = 8;
select
count(distinct device_id) as did_cnt,//总用户数:用户可以登录多次同一台设备
count(question_id) as question_cnt//总次数
from question_practice_detail qpd
where year(date) = 2021 and month(date) = 8;