select device_id from (select device_id,timestampdiff(month,concat(lag(ym,1,0)over(partition by device_id order by ym),'-01'),concat(ym,'-01')) monthdiff from (select device_id,date_format(event_date,'%Y-%m') ym,count(*) question_cnt from question_practice_detail group by device_id,ym having questio...