select

	MAT.CodeMat ,

	MAT.LibelleMat ,

	AVG(EVA.Note) as MoyClasse

from

	MATIERE as MAT

	inner join EVALUER as EVA on EVA.CodeMat=MAT.CodeMat

group by

	MAT.CodeMat,

	MAT.LibelleMat

order by

	MAT.LibelleMat

