Psychologie : Réponses

SELECT A.IndividuSource, P.Age, T.LbSexe, C.Lbcategorie, Sum(A.affinite) AS "Score" FROM AFFINITE A, TYPESEXE T, CATEGORIE C, PERSONNE P WHERE A.IndividuSource=P.Individu AND P.Sexe=T.Sexe AND P.Categorie=C.Categorie GROUP BY A.IndividuSource, P.Age, T.LbSexe, C.Lbcategorie ORDER BY 5 DESC;

SELECT P.Individu, P.Sexe AS "Sexe du leader", P1.Sexe, Sum(A.Affinite) AS "Score" FROM PERSONNE P, AFFINITE A, PERSONNE P1 WHERE P.Individu=A.IndividuSource AND A.IndividuBut=P1.Individu AND P.Individu='D' GROUP BY P.Individu, P.Sexe, P1.Sexe;

SELECT A.IndividuSource, A.IndividuBut, Sum(A.Affinite) AS "Score" FROM PERSONNE P, PERSONNE P1, AFFINITE A WHERE P.Individu=A.IndividuSource AND P1.Individu=A.IndividuBut AND P.Sexe=P1.Sexe GROUP BY A.IndividuSource, A.IndividuBut ORDER BY 3 DESC;

SELECT A.IndividuSource, A.IndividuBut, A1.IndividuBut, A.Affinite+A1.Affinite AS "Score" FROM PERSONNE P, PERSONNE P1, PERSONNE P2, AFFINITE A, AFFINITE A1 WHERE P.Individu=A.IndividuSource AND P1.Individu=A.IndividuBut AND P2.Individu=A1.IndividuBut AND A.IndividuSource=A1.IndividuSource AND A1.IndividuBut<>A.IndividuBut AND P.Sexe=1 AND P1.Sexe=1 AND P2.Sexe=1 AND P2.Sexe=1 ORDER BY 4 DESC;

SELECT C.Lbcategorie, Sum(CAST(A.Affinite AS Decimal(4,2)))/Count(Distinct P.Individu) AS "Moyenne" FROM AFFINITE A, PERSONNE P, CATEGORIE C WHERE A.IndividuSource=P.Individu AND P.Categorie=C.Categorie GROUP BY C.Lbcategorie HAVING Sum(A.Affinite)/Count(Distinct P.Individu) > 8;