WITH SEAT_STATUS AS (
    SELECT
        LINE_ID,
        SEAT_NO,
        RSV_STATUS,
        LAG(RSV_STATUS, 1) OVER (PARTITION BY LINE_ID ORDER BY SEAT_NO) AS PREV_RSV_STATUS,
        LEAD(RSV_STATUS, 1) OVER (PARTITION BY LINE_ID ORDER BY SEAT_NO) AS NEXT_RSV_STATUS
    FROM 
        SEAT_RESERVE
),
SEAT_GROUPS AS (
    SELECT
        LINE_ID,
        SEAT_NO,
        ROW_NUMBER() OVER (PARTITION BY LINE_ID ORDER BY SEAT_NO) - SEAT_NO AS GROUP_ID
    FROM 
        SEAT_STATUS
    WHERE 
        RSV_STATUS = '0'
),
CONSECUTIVE_SEATS AS (
    SELECT
        LINE_ID,
        MIN(SEAT_NO) AS SEAT_F,
        MAX(SEAT_NO) AS SEAT_T,
        COUNT(*) AS SEAT_COUNT
    FROM 
        SEAT_GROUPS
    GROUP BY 
        LINE_ID, GROUP_ID
)
SELECT
    LINE_ID AS LINE,
    SEAT_F,
    SEAT_T
FROM 
    CONSECUTIVE_SEATS
WHERE 
    SEAT_COUNT >= 3
ORDER BY 
    LINE_ID DESC,
    SEAT_F ASC;