select id, num, lead(num, 1) over (order by id) as lead_num, lag(num, 1) over (order by id) as lag_num lead(num, 1) over (order by id) as lead_num, lag(num, 1) over (order by id) as lag_num This part ...

In SQL, id is the primary key for this table. id is an autoincrement column. Find all numbers that appear at least three times consecutively. Return the result table in any order. The result format is ...