SELECT
    A.LINE
  , A.SEAT_F
  , A.SEAT_T
FROM
    (
        -- 抽出対象の割り出しSQL
        SELECT
            A.LINE_ID AS LINE
          , A.SEAT_NO AS SEAT_F
          , B.SEAT_NO AS SEAT_T
          , CASE
              WHEN B.SEAT_NO - A.SEAT_NO = 2 THEN '1' ELSE '0'
            END USE_INFO
        FROM
            SEAT_RESERVE AS A
            CROSS JOIN SEAT_RESERVE AS B
            ON  A.LINE_ID = B.LINE_ID
            AND B.RSV_STATUS = '0'
        WHERE
            A.RSV_STATUS = '0'
    ) AS A
WHERE
    A.USE_INFO = '1'
ORDER BY
    LINE DESC
  , SEAT_F ASC;