WITH NO_RSV AS (
SELECT 
    LINE_ID,SEAT_NO
FROM
    SEAT_RESERVE SR
WHERE RSV_STATUS = 0)

SELECT R1.LINE_ID LINE,R1.SEAT_NO SEAT_F ,R3.SEAT_NO SEAT_T
FROM 
    NO_RSV R1
INNER JOIN NO_RSV R2 ON R1.LINE_ID = R2.LINE_ID AND R1.SEAT_NO + 1 = R2.SEAT_NO
INNER JOIN NO_RSV R3 ON R1.LINE_ID = R3.LINE_ID AND R1.SEAT_NO + 2 = R3.SEAT_NO
ORDER BY R1.LINE_ID DESC,R1.SEAT_NO ASC