ChatGPT 1

Voici les requêtes SQL correspondantes à chacune de vos demandes :

SELECT "Titre"
FROM Film
WHERE "Genre" = 'Drame';
Copier

SELECT Film."Titre"
FROM Film
JOIN Projection ON Film."Num-Film" = Projection."Num-Film"
JOIN Cinéma ON Projection."Num-Ciné" = Cinéma."Num-Ciné"
WHERE Cinéma."Nom" = 'Le Fontenelle';
Copier

SELECT Individu."Nom", Individu."Prénom"
FROM Individu
JOIN Film ON Individu."Num-Ind" = Film."Num-Ind";
Copier

SELECT Individu."Nom", Individu."Prénom"
FROM Individu
JOIN Jouer ON Individu."Num-Ind" = Jouer."Num-Ind";
Copier

SELECT DISTINCT Individu."Nom", Individu."Prénom"
FROM Individu
JOIN Jouer ON Individu."Num-Ind" = Jouer."Num-Ind"
JOIN Film ON Jouer."Num-Film" = Film."Num-Film"
JOIN Individu AS Realisateur ON Film."Num-Ind" = Realisateur."Num-Ind";
Copier

SELECT "Titre"
FROM Film
JOIN Projection ON Film."Num-Film" = Projection."Num-Film"
WHERE Projection."Date" BETWEEN '2002-01-01' AND '2002-12-31';
Copier

SELECT "Titre"
FROM Film
JOIN Individu ON Film."Num-Ind" = Individu."Num-Ind"
WHERE Individu."Nom" = 'von Trier' AND Individu."Prénom" = 'Lars';
Copier

SELECT DISTINCT Realisateur."Nom", Realisateur."Prénom"
FROM Film
JOIN Individu AS Realisateur ON Film."Num-Ind" = Realisateur."Num-Ind"
WHERE Film."Genre" = 'Épouvante'
AND EXISTS (
    SELECT 1
    FROM Film AS F
    WHERE F."Genre" = 'Drame'
    AND F."Num-Ind" = Realisateur."Num-Ind"
);
Copier

SELECT Film."Titre"
FROM Film
JOIN Jouer ON Film."Num-Film" = Jouer."Num-Film"
JOIN Projection ON Film."Num-Film" = Projection."Num-Film"
JOIN Cinéma ON Projection."Num-Ciné" = Cinéma."Num-Ciné"
WHERE Jouer."Num-Ind" = (
        SELECT "Num-Ind"
        FROM Individu
        WHERE "Nom" = 'Kidman' AND "Prénom" = 'Nicole'
    )
AND Cinéma."Nom" = 'Le Fontenelle';
Copier

SELECT DISTINCT Individu."Nom", Individu."Prénom"
FROM Individu
JOIN Jouer ON Individu."Num-Ind" = Jouer."Num-Ind"
WHERE Jouer."Num-Film" NOT IN (
        SELECT "Num-Film"
        FROM Film
        WHERE "Genre" = 'Drame'
    );
Copier

SELECT DISTINCT I1."Nom", I1."Prénom"
FROM Individu AS I1
JOIN Individu AS I2 ON I1."Prénom" = I2."Prénom"
AND I1."Num-Ind" <> I2."Num-Ind"
JOIN Jouer ON I1."Num-Ind" = Jouer."Num-Ind"
JOIN Film ON Jouer."Num-Film" = Film."Num-Film"
JOIN Individu AS Realisateur ON Film."Num-Ind" = Realisateur."Num-Ind";
Copier

SELECT DISTINCT Individu."Nom", Individu."Prénom"
FROM Individu
JOIN Jouer ON Individu."Num-Ind" = Jouer."Num-Ind"
JOIN Film ON Jouer."Num-Film" = Film."Num-Film"
JOIN Projection ON Film."Num-Film" = Projection."Num-Film"
JOIN Cinéma ON Projection."Num-Ciné" = Cinéma."Num-Ciné"
WHERE Cinéma."Nom" = 'Le Fontenelle' AND Projection."Date" >= '2000-01-01';
Copier

SELECT "Titre"
FROM Film
JOIN Projection ON Film."Num-Film" = Projection."Num-Film"
GROUP BY "Titre"
HAVING MAX(Projection."Date") - MIN(Projection."Date") >= interval '5 years';
Copier

Ces requêtes devraient répondre à vos questions sur vos données de cinéma dans PostgreSQL.