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),