ChatGPT 2
Voici les requêtes SQL correspondant à chacune de vos demandes :
SELECT "Titre" FROM Film WHERE "Genre" = 'Drame';
SELECT F."Titre"
FROM Film F
JOIN Projection P ON F."Num-Film" = P."Num-Film"
JOIN Cinéma C ON P."Num-Ciné" = C."Num-Ciné"
WHERE C."Nom" = 'Le Fontenelle';
SELECT I."Nom", I."Prénom"
FROM Individu I
JOIN Film F ON I."Num-Ind" = F."Num-Ind";
SELECT I."Nom", I."Prénom"
FROM Individu I
JOIN Jouer J ON I."Num-Ind" = J."Num-Ind";
SELECT DISTINCT I."Nom", I."Prénom"
FROM Individu I
JOIN Jouer J ON I."Num-Ind" = J."Num-Ind"
WHERE I."Num-Ind" IN (SELECT "Num-Ind" FROM Film);
SELECT F."Titre"
FROM Film F
JOIN Projection P ON F."Num-Film" = P."Num-Film"
WHERE P."Date" BETWEEN '2002-01-01' AND '2002-12-31';
SELECT F."Titre"
FROM Film F
JOIN Individu I ON F."Num-Ind" = I."Num-Ind"
WHERE I."Nom" = 'von Trier' AND I."Prénom" = 'Lars';
SELECT I."Nom", I."Prénom"
FROM Individu I
JOIN Film F ON I."Num-Ind" = F."Num-Ind"
WHERE F."Genre" IN ('Épouvante', 'Drame')
GROUP BY I."Nom", I."Prénom"
HAVING COUNT(DISTINCT F."Genre") = 2;
SELECT F."Titre"
FROM Film F
JOIN Jouer J ON F."Num-Film" = J."Num-Film"
JOIN Projection P ON F."Num-Film" = P."Num-Film"
JOIN Cinéma C ON P."Num-Ciné" = C."Num-Ciné"
WHERE J."Num-Ind" = (SELECT "Num-Ind" FROM Individu WHERE "Nom" = 'Kidman' AND "Prénom" = 'Nicole')
AND C."Nom" = 'Le Fontenelle';
SELECT I."Nom", I."Prénom"
FROM Individu I
JOIN Jouer J ON I."Num-Ind" = J."Num-Ind"
JOIN Film F ON J."Num-Film" = F."Num-Film"
WHERE F."Genre" != 'Drame';
SELECT DISTINCT I1."Nom", I1."Prénom"
FROM Individu I1, Individu I2
WHERE I1."Prénom" = I2."Prénom" AND I1."Num-Ind" != I2."Num-Ind"
AND I1."Num-Ind" IN (SELECT "Num-Ind" FROM Jouer)
AND I2."Num-Ind" IN (SELECT "Num-Ind" FROM Film);
SELECT DISTINCT I."Nom", I."Prénom"
FROM Individu I
JOIN Jouer J ON I."Num-Ind" = J."Num-Ind"
JOIN Projection P ON J."Num-Film" = P."Num-Film"
JOIN Cinéma C ON P."Num-Ciné" = C."Num-Ciné"
WHERE C."Nom" = 'Le Fontenelle' AND EXTRACT(YEAR FROM P."Date") >= 2000;
SELECT F."Titre"
FROM Film F
JOIN Projection P ON F."Num-Film" = P."Num-Film"
WHERE P."Date" >= (F."Année" + INTERVAL '5 years');