SELECT num_ind, COUNT(num_film) FROM Jouer
	GROUP BY num_ind;
		
SELECT i.nom, i.prenom, COUNT(j.num_film) 
	FROM Individu i JOIN Jouer j
	ON i.num_ind=j.num_ind
	GROUP BY i.nom, i.prenom;
	
SELECT i.nom, i.prenom, COUNT(j.num_film) 
	FROM Individu i JOIN Jouer j
	ON i.num_ind=j.num_ind
	GROUP BY i.nom, i.prenom
	HAVING COUNT(j.num_film)>1;
	
SELECT i.nom, i.prenom, COUNT(j.num_film)
	FROM Individu i JOIN Jouer j
	ON i.num_ind=j.num_ind
	GROUP BY i.nom, i.prenom
	ORDER BY COUNT(j.num_film) DESC ;


SELECT c.nom, MIN(d.pdate)
	FROM Cinema c JOIN Projection d
	ON c.num_cine=d.num_cine
	GROUP BY c.nom;
	
SELECT nom, prenom
	FROM Individu i, Jouer j, Film f
	WHERE i.num_ind=j.num_ind
	AND j.num_film=f.num_film
	GROUP BY nom, prenom
	HAVING COUNT (DISTINCT f.num_film) = (SELECT COUNT(num_film) FROM Film);
	
SELECT nom, prenom
	FROM Individu i, Jouer j, Film f
	WHERE i.num_ind=j.num_ind
	AND j.num_film=f.num_film
	GROUP BY nom, prenom
	HAVING COUNT (DISTINCT f.num_film) > (SELECT AVG(num_ind) FROM Jouer);