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