WITH t1 AS (SELECT LINE_ID,SEAT_NO
            FROM SEAT_RESERVE
            WHERE RSV_STATUS ='0'),
            t2 AS (SELECT LINE_ID,SEAT_NO
            FROM SEAT_RESERVE
            WHERE RSV_STATUS ='0'),
            t3 AS (SELECT LINE_ID,SEAT_NO
            FROM SEAT_RESERVE
            WHERE RSV_STATUS ='0')
select t1.LINE_ID AS LINE ,t1.SEAT_NO AS SEAT_F,t3.SEAT_NO AS SEAT_T
from t1,t2,t3
where t1.LINE_ID = t2.LINE_ID 
and t1.LINE_ID = t3.LINE_ID 
and t1.SEAT_NO+1 = t2.SEAT_NO 
and t1.SEAT_NO+2 = t3.SEAT_NO 
order by LINE DESC, SEAT_F ASC