INSERT INTO Client1 VALUES (5,'Dupond','Jean','1 avenue du Parc CERGY',95000);
INSERT INTO Client1 VALUES (3,'Martin','Philippe','35 Champs Elysées Paris',75008);  ## l'emplacement 2 est déjà pris => on le met en 3
INSERT INTO Client1 VALUES (4,'Martin','Philippe','35 Champs Elysées Paris',75008);

INSERT INTO Commande1 VALUES (1,to_date('30/08/2008'),2);
INSERT INTO Commande1 VALUES (2,NULL,5);

INSERT INTO Ligne_commande1 VALUES (1,1,1,1,5);
INSERT INTO Ligne_commande1 VALUES (2,1,1,2,53);
INSERT INTO Ligne_commande1 VALUES (3,5,2,1,7);

UPDATE Client1 SET code_postal=77305 where adresse='35 rue St Honoré Fontainebleau';
DELETE From Produit1 where libelle like '%Cracotte%';
DELETE From Client1 where nom='Dupond' and prenom='Francois';

SELECT stock*prix as total from Produit1;
SELECT sum(stock*prix) as Prixtotal from Produit1;
SELECT avg(prix) as Moyenne from Produit1;
SELECT * FROM Produit where prix=('');

SELECT COUNT(*) FROM commande where to_char(date, 'DDMMYYYY') like '%2007';
SELECT libelle FROM Produit where prix=(select prix from produit where libelle like '%Nectar de mangue');
SELECT libelle FROM Produit where prix>(select avg(prix) from produit);
SELECT nom,prenom from Client where id in (select id_Client from commande where cdate>date'2008-01-01');
SELECT no_commande,cdate,id_client from commande where no_commande in(select no_commande from ligne_commande where quantite between 50 and 200);
SELECT no_commande,cdate,id_client from commande where no_commande in(select no_commande from ligne_commande where id_produit in (select id from produit where libelle like '%Evian%'));


ex3

intersection : Produit_prenom(individu) inter produit_role(jouer)			produit = pi MAJ
SQL select prenom from individu intersect select role from film;

union : produit_prenom(individu) union produit_role(film)
SQL select prenom from individu union select role from jouer;

difference : produit_nom(somme_prenom(like 'T%' or '%W')(individu)) - produit_nom(somme_prenom(like 'John')(individu))
SQL select nom from individu where nom like 'T%' or nom like 'W%' minus select nom from individu where prenom like 'John';

produit cartesien : individu X film
SQL select * from Individu, film;

5) errreur

select nom,prenom from individu where num_id in (select num_id from jouer) union select nom,prenom from individu where nom_id in (select num_id from film);

select nom,prenom from individu intersect ----- idem

select nom,prenom from individu where id in (select num_id from jouer) minus select nom,prenom from individu where nom_id in (select num_id from film where genre='Dramatique');