select C.LINE_ID as LINE, C.SEAT_NO as SEAT_F, C.SEAT_NO+2 as SEAT_T from 
(select A.* from  SEAT_RESERVE A,
(select * from SEAT_RESERVE where RSV_STATUS = 0) B
where A.RSV_STATUS = 0
and (A.LINE_ID = B.LINE_ID and A.SEAT_NO + 1 = B.SEAT_NO)
) C,
(select * from SEAT_RESERVE where RSV_STATUS = 0) D
where (C.LINE_ID = D.LINE_ID and C.SEAT_NO + 2 =D.SEAT_NO)
order by C.LINE_ID desc ,
C.SEAT_NO