--予約可の席を表示
WITH b AS (
    SELECT
        LINE_ID
        ,SEAT_NO
    FROM
        SEAT_RESERVE
    WHERE
        RSV_STATUS = '0'
    )
,c AS (
    SELECT
        LINE_ID
        ,SEAT_NO
    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_RESERVE AS a
INNER JOIN
    b
  ON a.LINE_ID = b.LINE_ID
    AND a.SEAT_NO + 1 = b.SEAT_NO
INNER JOIN
    c
  ON a.LINE_ID = c.LINE_ID
    AND a.SEAT_NO + 2 = c.SEAT_NO
WHERE
        RSV_STATUS = '0'
ORDER BY
    LINE DESC
    ,SEAT_F ASC;