create view SecondeVue as
select
    Nom ,
    Prenom ,
    sum(CoeffMat * MoyenneMat) / sum(CoeffMat) as moyenne
from 
    MoyGenEtud
group by 
    Nom ,
    Prenom