Series d’exercices SQL/Oracle

FROM Client ;

2) SELECT Desi
FROM Client
WHERE PrixUni 500 ;

5) SELECT NumCli
FROM Client C1
WHERE NOT EXISTS (
SELECT *
FROM Commande C2
WHERE C2.NumCLi = C1.NumCli
AND NumProd = 1) ;

6) SELECT NumCLi
FROM Client C1
WHERE NOT EXISTS ( SELECT *
FROM Produit P W HERE NOT EXISTS (
SELECT *
FROM Commande C2
WHERE C2.NumCli = C1.NumCli
AND C2.NumProd = P.NumProd)) ;

7) SELECT Nom
FROM Client C0
WHERE NOT EXISTS (
SELECT *
FROM Commande C1
WHERE NumCli = 2
AND NOT EXISTS (
SELECT *
FROM Commande C2
WHERE C2.NumCli = C0.NumCli
AND C2.NumProd = C1.NumProd)) ;

Correction Exercice 2

CREATE TABLE CLIENT (NOC NUMBER(3),
NOM VARCHAR(40),
ADRESSE VARCHA R(100),