select device_id from ( select date1, device_id, num, lag(date1, 1) over(partition by device_id order by date1 asc) as date2 from ( select substr(event_date,1,7) as date1,device_id, count(*) as num from question_practice_detail group by substr(event_date,...