SELECT
      tmp.LINE_ID LINE
    , tmp.SEAT_NO SEAT_F
    , tmp.max_seat SEAT_T 
FROM
    (
        SELECT
              LINE_ID
            , SEAT_NO
            , MAX(SEAT_NO) OVER ( 
                PARTITION BY
                    LINE_ID 
                ORDER BY
                    SEAT_NO ROWS BETWEEN 2 PRECEDING AND 2 FOLLOWING
            ) max_seat 
        FROM
            SEAT_RESERVE 
        WHERE
            RSV_STATUS = '0'
    ) tmp 
WHERE
    tmp.max_seat - tmp.SEAT_NO = 2 
ORDER BY
    LINE DESC
    , SEAT_F ASC
;