BDD

Partie 1)

Exercice 1)

1.	SELECT * FROM Film
			WHERE annee <= 1996;
			
2.	SELECT * FROM Film
			WHERE annee >= 2000 and genre = 'Drame';
			
3.	SELECT * FROM Film
			WHERE annee <= 2000 AND genre <> 'Policier');
			
4.	SELECT titre AND genre AND annee
			FROM Film
			
5.	SELECT * FROM Film
			WHERE annee < 2000;
	SELECT DISTINCT genre
			FROM Film;
			
Exercice 2)

1. Projection_genre((Film)) --> PI
2. Projection_titre(genre='Drame'(Film))
3. Projection_prenom(Sigma_nom='Tarantino'(Individu))
4. Projection_genre,annee(Sigma_titre='Dogville'(Film))
5. Projection_adresse(Sigma_nom='Gaumont Wilson'(Cinema))


Partie 2)

1.  select * from individu;
2.  select prenom from individu;
3.  select prenom from individu order by prenom;
4.  select distinct prenom from individu;
    select distinct prenom from individu order by prenom;	-- On obtient la même chose --
5.	select * from individu where prenom = 'John';
6.	select nom from individu where prenom = 'John';
7/8.	select prenom from individu where lower(prenom) like '%s%';
9.	select prenom from individu where upper(prenom) like 'S%';
10.	select prenom from individu where upper(prenom) like '%S';
11.	select prenom from individu where upper(prenom) not like '%E%';
12.	select prenom from individu where upper(prenom) like '%A%' and upper(prenom) like '%L%';
13.	select nom from individu where upper(nom) like '%AN%' or upper(nom) like '%ON%';
14.	select titre from film where lower(titre) like '%e%e%e%'; 
15.	select projection from film where annee = 1996;