WITH q1 AS (
    SELECT
        LINE_ID AS LINE,
        SEAT_NO AS SEAT_F,
        SEAT_NO + 2 AS SEAT_T,
        RSV_STATUS AS stt_1,
        lead(RSV_STATUS, 1) OVER (
            PARTITION BY LINE_ID
            ORDER BY
                LINE_ID,
                SEAT_NO
        ) AS stt_2,
        lead(RSV_STATUS, 2) OVER (
            PARTITION BY LINE_ID
            ORDER BY
                LINE_ID,
                SEAT_NO
        ) AS stt_3
    FROM
        SEAT_RESERVE
)
SELECT
    LINE,
    SEAT_F,
    SEAT_T
FROM
    q1
WHERE
    stt_1 = '0'
    AND stt_2 = '0'
    AND stt_3 = '0'
ORDER BY
    LINE DESC,
    SEAT_F