Bonjour,
select sum(sum(ev.Note*m.CoeffMat)/SUM(m.CoeffMat)) from evaluer ev join matiere m on m.CodeMat=ev.CodeMat full outer join
etudiant e on e.Netudiant=ev.Netudiant group by e.Netudiant
j ai un problem quand j ai fait sum de sum
Msg 130, Level 15, State 1, Line 1
Cannot perform an aggregate function on an expression containing an aggregate or a subquery.
j ai besion de vos solution et merci pour vous