WITH ConsecutiveSeats AS (
    SELECT
        s1.LINE_ID,
        s1.SEAT_NO AS SEAT_F,
        s1.SEAT_NO + 2 AS SEAT_T
    FROM
        SEAT_RESERVE s1
    JOIN
        SEAT_RESERVE s2 ON s1.LINE_ID = s2.LINE_ID AND s1.SEAT_NO + 1 = s2.SEAT_NO AND s1.RSV_STATUS = '0' AND s2.RSV_STATUS = '0'
    JOIN
        SEAT_RESERVE s3 ON s2.LINE_ID = s3.LINE_ID AND s2.SEAT_NO + 1 = s3.SEAT_NO AND s3.RSV_STATUS = '0'
    WHERE
        s1.RSV_STATUS = '0'
)
SELECT
    LINE_ID AS LINE,
    SEAT_F,
    SEAT_T
FROM
    ConsecutiveSeats
ORDER BY
    LINE DESC,
    SEAT_F ASC;