SELECT
T1.LINE_ID LINE,
T1.SEAT_NO SEAT_F,
T1.SEAT_NO+2 SEAT_T
FROM SEAT_RESERVE T1
WHERE
    T1.RSV_STATUS = '0'
AND EXISTS (
 SELECT 'X' FROM SEAT_RESERVE T2
 WHERE
     T1.LINE_ID = T2.LINE_ID
 AND T1.SEAT_NO +1 = T2.SEAT_NO
 AND T2.RSV_STATUS = '0'
)
AND EXISTS (
 SELECT 'X' FROM SEAT_RESERVE T3
 WHERE
     T1.LINE_ID = T3.LINE_ID
 AND T1.SEAT_NO +2 = T3.SEAT_NO
 AND T3.RSV_STATUS = '0'
)
ORDER BY LINE_ID DESC,T1.SEAT_NO ASC