with
w as (
  select
      LINE_ID
    , SEAT_NO 
    , lead(RSV_STATUS, 0) over(partition by LINE_ID order by LINE_ID asc) as L_0
    , lead(RSV_STATUS, 1) over(partition by LINE_ID order by LINE_ID asc) as L_1
    , lead(RSV_STATUS, 2) over(partition by LINE_ID order by LINE_ID asc) as L_2
    , lead(SEAT_NO   , 2) over(partition by LINE_ID order by LINE_ID asc) as LAST_SEAT_NO
  from
    SEAT_RESERVE
)
select
    LINE_ID      as LINE
  , SEAT_NO      as SEAT_F
  , LAST_SEAT_NO as SEAT_T
from
  w
where
    L_0 = '0'
and L_1 = '0'
and L_2 = '0'
order by
    LINE   desc
  , SEAT_F asc
;