SELECT 
    LINE_ID AS LINE,
    SEAT_NO AS SEAT_F,
    SEAT_NO + 2 AS SEAT_T
FROM 
    SEAT_RESERVE sr1
WHERE 
    RSV_STATUS = '0'
    AND EXISTS (
        SELECT 1 
        FROM SEAT_RESERVE sr2 
        WHERE sr2.LINE_ID = sr1.LINE_ID 
        AND sr2.SEAT_NO = sr1.SEAT_NO + 1 
        AND sr2.RSV_STATUS = '0'
    )
    AND EXISTS (
        SELECT 1 
        FROM SEAT_RESERVE sr3 
        WHERE sr3.LINE_ID = sr1.LINE_ID 
        AND sr3.SEAT_NO = sr1.SEAT_NO + 2 
        AND sr3.RSV_STATUS = '0'
    )
ORDER BY 
    LINE_ID DESC,
    SEAT_NO ASC;