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