WITH A AS ( 
    SELECT LINE_ID
    ,SEAT_NO
    ,RSV_STATUS
    ,LEAD(RSV_STATUS,1) OVER (PARTITION BY LINE_ID ORDER BY SEAT_NO) AS NEXT1
    ,LEAD(RSV_STATUS,2) OVER (PARTITION BY LINE_ID ORDER BY SEAT_NO) AS NEXT2
    FROM SEAT_RESERVE
    )
SELECT LINE_ID LINE
    ,SEAT_NO SEAT_F
    ,SEAT_NO + 2 SEAT_T
FROM
    A
WHERE
    RSV_STATUS = '0'
AND NEXT1 = '0'
AND NEXT2 = '0'
ORDER BY
    LINE_ID DESC
    ,SEAT_NO ASC