WITH ConsecutiveSeats AS (
    SELECT
        LINE_ID,
        SEAT_NO,
        LEAD(SEAT_NO, 1) OVER (PARTITION BY LINE_ID ORDER BY SEAT_NO) AS NextSeat1,
        LEAD(SEAT_NO, 2) OVER (PARTITION BY LINE_ID ORDER BY SEAT_NO) AS NextSeat2
    FROM SEAT_RESERVE
    WHERE RSV_STATUS = '0'
)
SELECT
    LINE_ID AS LINE,
    SEAT_NO AS SEAT_F,
    NextSeat2 AS SEAT_T
FROM ConsecutiveSeats
WHERE
    NextSeat1 = SEAT_NO + 1
    AND NextSeat2 = SEAT_NO + 2
ORDER BY
    LINE_ID DESC,
    SEAT_NO ASC;