WITH TMP (LINE_ID, SEAT_NO_START, SEAT_NO_END, RSV_STATUS, RSV_STATUS_LEAD1, RSV_STATUS_LEAD2) AS (
    SELECT
        LINE_ID
        , SEAT_NO AS SEAT_NO_START
        , LEAD(SEAT_NO, 2) OVER(PARTITION BY LINE_ID ORDER BY SEAT_NO) AS SEAT_NO_END
        , RSV_STATUS
        , LEAD(RSV_STATUS, 1) OVER(PARTITION BY LINE_ID ORDER BY SEAT_NO) AS RSV_STATUS_LEAD1
        , LEAD(RSV_STATUS, 2) OVER(PARTITION BY LINE_ID ORDER BY SEAT_NO) AS RSV_STATUS_LEAD2
    FROM
        SEAT_RESERVE
    ORDER BY
        LINE_ID, SEAT_NO
)

SELECT
    LINE_ID AS LINE
    , SEAT_NO_START AS SEAT_F
    , SEAT_NO_END AS SEAT_T
FROM
    TMP
WHERE
    RSV_STATUS = '0'
    AND RSV_STATUS_LEAD1 = '0'
    AND RSV_STATUS_LEAD2 = '0'
ORDER BY
    LINE_ID DESC, SEAT_NO_START