SELECT
    sr1.LINE_ID AS LINE,
    sr1.SEAT_NO AS SEAT_F,
    sr3.SEAT_NO AS SEAT_T
FROM
    SEAT_RESERVE AS sr1
    INNER JOIN SEAT_RESERVE AS sr2 ON sr1.SEAT_NO + 1 = sr2.SEAT_NO
    AND sr1.LINE_ID = sr2.LINE_ID
    AND sr2.RSV_STATUS = 0
    INNER JOIN SEAT_RESERVE AS sr3 ON sr1.SEAT_NO + 2 = sr3.SEAT_NO
    AND sr1.LINE_ID = sr3.LINE_ID
    AND sr3.RSV_STATUS = 0
WHERE
    sr1.RSV_STATUS = 0
ORDER BY
    LINE DESC,
    SEAT_F ASC;