select 
test0.LINE_ID AS ILINE
,test0.SEAT_NO AS SEAT_F
,test0.SEAT_NO+2 AS SEAT_T
from SEAT_RESERVE test0



inner join SEAT_RESERVE  AS test1
on test0.SEAT_NO = test1.SEAT_NO+1
and test0.LINE_ID = test1.LINE_ID
and test1.RSV_STATUS = 0

inner join SEAT_RESERVE  AS test2
on test1.SEAT_NO = test2.SEAT_NO+1
and test1.LINE_ID = test2.LINE_ID
and test2.RSV_STATUS = 0

and test0.RSV_STATUS = 0
order by test0.LINE_ID desc,test0.SEAT_NO