WITH RECURSIVE SeatGroups AS (
    SELECT 
        LINE_ID, 
        SEAT_NO, 
        RSV_STATUS, 
        SEAT_NO AS StartSeat, 
        SEAT_NO AS EndSeat, 
        1 AS Count
    FROM 
        SEAT_RESERVE
    WHERE 
        RSV_STATUS = '0'
    
    UNION ALL
    
    SELECT 
        sg.LINE_ID, 
        sr.SEAT_NO, 
        sr.RSV_STATUS, 
        sg.StartSeat, 
        sr.SEAT_NO, 
        sg.Count + 1
    FROM 
        SeatGroups sg
    JOIN 
        SEAT_RESERVE sr
    ON 
        sg.LINE_ID = sr.LINE_ID
        AND sg.EndSeat + 1 = sr.SEAT_NO
        AND sr.RSV_STATUS = '0'
)
SELECT 
    LINE_ID AS LINE,
    StartSeat AS SEAT_F,
    EndSeat AS SEAT_T
FROM 
    SeatGroups
WHERE 
    Count = 3
ORDER BY 
    LINE_ID DESC, 
    StartSeat ASC;