with
  abv as (
    select
      line_id,
      seat_no as SEAT_M,
      rsv_status,
      lag (seat_no) over (
        partition by
          line_id
        order by
          line_id,
          seat_no
      ) as SEAT_F,
      lead (seat_no) over (
        partition by
          line_id
        order by
          line_id,
          seat_no
      ) as SEAT_T
    from
      SEAT_RESERVE
    where
      RSV_STATUS = '0'
  )
select
  abv.line_id as LINE,
  abv.SEAT_F as SEAT_F,
  abv.SEAT_T as SEAT_T
from
  abv
 where
  abv.SEAT_T - abv.SEAT_F =2
order by
  LINE_ID desc,
  SEAT_F;