SELECT 

    nom ,

    prenom ,

    SUM(coef*moyenne)/(SELECT SUM(coef) FROM matieres) AS  MoyGen

FROM 

    mavue

GROUP BY 

    nom ,

    prenom