select
  LINE_ID as LINE
 ,SEAT_NO as SEAT_F
 ,SEAT_NO + 2 as SEAT_T
from
 (select
   LINE_ID
  ,SEAT_NO
  ,LEAD(RSV_STATUS, 0) OVER (ORDER BY LINE_ID asc, SEAT_NO asc) as RSV_STATUS1
  ,LEAD(RSV_STATUS, 1) OVER (ORDER BY LINE_ID asc, SEAT_NO asc) as RSV_STATUS2
  ,LEAD(RSV_STATUS, 2) OVER (ORDER BY LINE_ID asc, SEAT_NO asc) as RSV_STATUS3
 from
  (select
   *
  from
   SEAT_RESERVE
  )
 )
where
 RSV_STATUS1 = '0' and RSV_STATUS2 = '0' and RSV_STATUS3 = '0'
order by
 LINE desc, SEAT_F asc
;