select count(distinct device_id) ,count(question_id) from question_practice_detail where year(date) = '2021' and month(date) = '08' #where date like "2021-08%" #where date_format(date, '%Y-%m')='2021-08' #where substring(date,1,7) = '2021-08' #where...