select
     LINE_ID
     ,SEAT_NO as SEAT_F
     ,SEAT_2 as SEAT_T
from (
  select LINE_ID
        ,SEAT_NO
        ,LEAD(SEAT_NO,1) over (partition  by LINE_ID order by LINE_ID,SEAT_NO asc) as SEAT_1
        ,LEAD(SEAT_NO,2) over (partition  by LINE_ID order by LINE_ID,SEAT_NO asc) as SEAT_2
  from SEAT_RESERVE SR
  where SR.RSV_STATUS = '0'
) test
where SEAT_1 - SEAT_NO = 1
  and SEAT_2 - SEAT_NO = 2
order by LINE_ID desc,SEAT_NO asc