1) SELECT num_film, COUNT (*) FROM Jouer GROUP BY num_film;
	SELECT genre, COUNT (*) FROM Film GROUP BY genre;
	
2) SELECT nom, prenom FROM Individu i, Film f WHERE i.num_ind=f.num_ind AND LOWER(titre) like 'pulp fiction';

3) SELECT titre FROM Individu i, Film f WHERE i.num_ind=f.num_ind AND nom='von Trier' AND prenom='Lars';
	SELECT titre FROM individu.i JOIN film.f ON i.num_ind=f.num_ind WHERE nom='Von Trier' AND prenom='Lars';
	
4) SELECT titre FROM Film f, Projection p WHERE f.num_film=p.num_film AND to_char(pdate, 'DDMMYYYY') LIKE '%2002';

5) SELECT nom, prenom FROM Individu i, Jouer j WHERE i.num_ind=j.num_ind INTERSECT SELECT nom, prenom FROM Individu i, Film f WHERE i.num_ind=f.num_ind;
	SELECT nom, prenom FROM Individu i, Jouer j, Film f WHERE i.num_ind=j.num_ind AND i.num_ind=f.num_ind;

6) SELECT nom, prenom FROM Individu i, Jouer j, Film f WHERE i.num_ind=j.num_ind AND j.num_film=f.num_film AND f.genre not like 'Drame';

7) cf cours

8) SELECT DISTINCT titre FROM Individu i, Film f, Jouer j, Projection p, Cinema c  WHERE c.num_cine=p.num_cine AND p.num_film=f.num_film AND f.num_film=j.num_film AND i.num_ind=j.num_ind AND c.nom='Le Fontenelle' AND i.nom='Kidman' AND i.prenom='Nicole';

9) SELECT nom, prenom, COUNT(num_film) FROM Individu i, Jouer j WHERE i.num_ind=j.num_ind GROUP BY nom, prenom