SELECT count(candidat_id), dbo.diplome.nom, dbo.filiere.CODEFILIERE, dbo.UFR.TITREUFR FROM dbo.diplome_preparer inner join dbo.SPECIALITE on dbo.diplome_preparer.codedipprep = dbo.SPECIALITE.codedipprep INNER JOIN dbo.filiere on dbo.SPECIALITE.CODESP = dbo.filiere.CODESP INNER JOIN dbo.UFR on dbo.filiere.CODEFILIERE = dbo.UFR.CODEFILIERE INNER JOIN dbo.candidat on dbo.candidat.codedip = specialite.codedip INNER JOIN diplome on diplome_preparer.iddiplome = diplome.iddiplome group by dbo.diplome.nom, dbo.filiere.CODEFILIERE, dbo.UFR.TITREUFR
select count(etudiant), classe_nom from etudiant inner join classe on classe.classe_id = etudiant.class_id group by classe_nom
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question