WITH NumberedSeats AS (
    SELECT
        LINE_ID,
        SEAT_NO,
        RSV_STATUS,
        ROW_NUMBER() OVER (PARTITION BY LINE_ID ORDER BY SEAT_NO) AS rn
    FROM
        SEAT_RESERVE
    WHERE
        RSV_STATUS = '0'
),
GroupedSeats AS (
    SELECT
        LINE_ID,
        SEAT_NO,
        ROW_NUMBER() OVER (PARTITION BY LINE_ID ORDER BY SEAT_NO) -
        ROW_NUMBER() OVER (PARTITION BY LINE_ID ORDER BY rn) AS grp
    FROM
        NumberedSeats
),
ConsecutiveSeats AS (
    SELECT
        LINE_ID,
        MIN(SEAT_NO) AS SEAT_F,
        MIN(SEAT_NO) + 2 AS SEAT_T,
        COUNT(*) AS cnt
    FROM
        GroupedSeats
    GROUP BY
        LINE_ID, grp
    HAVING
        COUNT(*) >= 3
)
SELECT
    LINE_ID AS LINE,
    SEAT_F,
    SEAT_T
FROM
    ConsecutiveSeats
ORDER BY
    LINE DESC,
    SEAT_F ASC;