WITH three_seats AS (
    SELECT
        LINE_ID,
        SEAT_NO,
        LEAD(SEAT_NO, 1) OVER (PARTITION BY LINE_ID ORDER BY SEAT_NO) AS NEXT_SEAT_NO1,
        LEAD(SEAT_NO, 2) OVER (PARTITION BY LINE_ID ORDER BY SEAT_NO) AS NEXT_SEAT_NO2,
        RSV_STATUS,
        LEAD(RSV_STATUS, 1) OVER (PARTITION BY LINE_ID ORDER BY SEAT_NO) AS NEXT_RSV_STATUS1,
        LEAD(RSV_STATUS, 2) OVER (PARTITION BY LINE_ID ORDER BY SEAT_NO) AS NEXT_RSV_STATUS2
    FROM SEAT_RESERVE
)
SELECT
    LINE_ID AS LINE,
    SEAT_NO AS SEAT_F,
    NEXT_SEAT_NO2 AS SEAT_T
FROM
    three_seats
WHERE
    RSV_STATUS = '0' AND
    NEXT_RSV_STATUS1 = '0' AND
    NEXT_RSV_STATUS2 = '0'
ORDER BY
    LINE_ID DESC,
    SEAT_NO ASC;