-- 座席予約テーブルから連続した3つの予約されていない席を探して表示
SELECT
    LINE_ID AS LINE,
    SEAT_NO AS SEAT_F,
    SEAT_NO + 2 AS SEAT_T
FROM
    SEAT_RESERVE sr1
WHERE
    RSV_STATUS = '0' AND
    EXISTS (
        SELECT 1
        FROM SEAT_RESERVE sr2
        WHERE sr2.LINE_ID = sr1.LINE_ID AND sr2.SEAT_NO = sr1.SEAT_NO + 1 AND sr2.RSV_STATUS = '0'
    ) AND
    EXISTS (
        SELECT 1
        FROM SEAT_RESERVE sr3
        WHERE sr3.LINE_ID = sr1.LINE_ID AND sr3.SEAT_NO = sr1.SEAT_NO + 2 AND sr3.RSV_STATUS = '0'
    )
ORDER BY
    LINE_ID DESC,
    SEAT_NO ASC;