1 2 3 4 5 6 7
| select inscription.NumInsc,nom_prenom,sexe,inscription.annee_scolaire,niveau.libniveau,unite.libunite,matiere.libmatiere,note,(note * coef)as'note*coef',(sum(note * coef)/sum(coef )) as 'moy'from inscription
inner join niveau on inscription.IDniveau=niveau.IDniveau
inner join evaluation on inscription.NumInsc=evaluation.NumInsc
inner join matiere on evaluation.IDmat=matiere.IDmat
inner join unite on matiere.IDunite=unite.IDunite
where unite.libunite like 'français' and inscription.NumInsc like '100'
group by inscription.NumInsc,nom_prenom,sexe,inscription.annee_scolaire,niveau.libniveau,matiere.libmatiere,note,coef,unite.libunite |
Partager