
CREATE VIEW realisateurFilmsDrama AS
	SELECT nom, prenom, annee
	FROM film,individu
	WHERE film.num_ind=individu.num_ind AND film.genre LIKE 'Drame'
;

