select
	MAT.CodeMat ,
	MAT.LibelleMat ,
	avg(EVA.Note) as MoyClasse
from
	MATIERE as MAT
	join EVALUER as EVA 
    on EVA.CodeMat=MAT.CodeMat