WITH SEAT_CTE AS (
    SELECT 
        LINE_ID,
        SEAT_NO,
        RSV_STATUS,
        LEAD(RSV_STATUS, 1) OVER (PARTITION BY LINE_ID ORDER BY SEAT_NO) AS NEXT_RSV_STATUS,
        LEAD(RSV_STATUS, 2) OVER (PARTITION BY LINE_ID ORDER BY SEAT_NO) AS NEXT_NEXT_RSV_STATUS,
        LEAD(SEAT_NO, 2) OVER (PARTITION BY LINE_ID ORDER BY SEAT_NO) AS THIRD_SEAT_NO
    FROM 
        SEAT_RESERVE
)
SELECT 
    LINE_ID AS LINE,
    SEAT_NO AS SEAT_F,
    THIRD_SEAT_NO AS SEAT_T
FROM 
    SEAT_CTE
WHERE 
    RSV_STATUS = '0' 
    AND NEXT_RSV_STATUS = '0' 
    AND NEXT_NEXT_RSV_STATUS = '0'
ORDER BY LINE_ID DESC,SEAT_NO ASC