create view MoyGenEtu as
select
	ETU.NumEtudiant,
	ETU.Nom,
	ETU.Prenom,
	MAT.LibelleMat,
	MAT.CoeffMat,
	avg(EVA.Note) as MoyenneMat
from
	ETUDIANT as ETU
	inner join EVALUER as EVA 
		on EVA.NumEtudiant = ETU.NumEtudiant
	inner join MATIERE as MAT 
		on MAT.CodeMat = EVA.CodeMat
group by
	ETU.NumEtudiant,
	ETU.Nom,
	ETU.Prenom,
	MAT.LibelleMat,
	MAT.CoeffMat
order by
	ETU.Nom