select day(date) as day ,count(device_id) as question_cnt from question_practice_detail
where year(date)=2021&&month(date)=8
group by date;