select

	MAT.CodeMat ,

	MAT.LibelleMat ,

	avg(EVA.Note) as MoyClasse

from

	MATIERE as MAT

	inner join EVALUER as EVA 

    on EVA.CodeMat=MAT.CodeMat