WITH
    tmp AS (
        SELECT
            LINE_ID AS LINE,
            SEAT_NO AS SEAT
        FROM
            SEAT_RESERVE
        WHERE
            RSV_STATUS = 0
    )
SELECT
    LINE_ID AS LINE,
    SEAT_NO AS SEAT_F,
    SEAT_NO + 2 AS SEAT_T
FROM
    SEAT_RESERVE
WHERE
    (LINE_ID, SEAT_NO) IN (
        SELECT
            LINE,
            SEAT
        FROM
            tmp
    )
    AND (LINE_ID, SEAT_NO + 1) IN (
        SELECT
            LINE,
            SEAT
        FROM
            tmp
    )
    AND (LINE_ID, SEAT_NO + 2) IN (
        SELECT
            LINE,
            SEAT
        FROM
            tmp
    )
ORDER BY
    LINE DESC,
    SEAT_F ASC;