WITH res AS (
    SELECT
        LINE_ID,
        SEAT_NO,
        sum(RSV_STATUS) over (
            PARTITION by LINE_ID
            ORDER BY
                SEAT_NO ROWS BETWEEN 1 PRECEDING
                AND 1 FOLLOWING
        ) AS SRS
    FROM
        SEAT_RESERVE
)
SELECT
    LINE_ID AS 'LINE',
    SEAT_NO - 1 AS 'SEAT_F',
    SEAT_NO + 1 AS 'SEAT_T'
FROM
    res
WHERE
    SEAT_NO <> 1
    AND SEAT_NO <> 15
    AND res.SRS = 0
ORDER BY
    LINE DESC,
    SEAT_F ASC