with tmp as( select device_id,date_format(event_date,'%Y-%m') ym,count(*) cnt from question_practice_detail group by device_id,ym ) select device_id,ym, round(sum(cnt) over sum_cnt,2) as sum_cnt, round(sum(cnt) over sum_3cnt / count(cnt) over sum_3cnt,2) as avg3_cnt, round(sum(cnt) over...