WITH SEAT_GROUPS AS (
    SELECT
        LINE_ID,
        SEAT_NO,
        ROW_NUMBER() OVER (PARTITION BY LINE_ID ORDER BY SEAT_NO) AS ROW_NUM
    FROM
        SEAT_RESERVE
    WHERE
        RSV_STATUS = '0'
)
SELECT
    A.LINE_ID AS LINE,
    A.SEAT_NO AS SEAT_F,
    C.SEAT_NO AS SEAT_T
FROM
    SEAT_GROUPS A
JOIN
    SEAT_GROUPS B ON A.LINE_ID = B.LINE_ID AND A.ROW_NUM = B.ROW_NUM - 1
JOIN
    SEAT_GROUPS C ON A.LINE_ID = C.LINE_ID AND A.ROW_NUM = C.ROW_NUM - 2
WHERE
    B.SEAT_NO = A.SEAT_NO + 1 AND C.SEAT_NO = B.SEAT_NO + 1
ORDER BY
    A.LINE_ID DESC,
    A.SEAT_NO ASC;