Sociologie : Réponses

SELECT Count(*) AS "Individus" FROM REPONSE R, REPONSE R1, REPONSE R2 WHERE R.numind=R1.numind AND R1.numind=R2.numind AND (R.Numquest=1 AND R.Cdrep=1) AND (R1.Numquest=2 AND R1.Cdrep=2) AND (R2.Numquest=3 AND R2.Cdrep=3);

SELECT L.Lbreponse, Avg(CAST(E.Fratrie AS DECIMAL(3,1))) AS "Moyenne De Fratrie" FROM ECHANTILLON E, LIBELLE_REPONSE L, REPONSE R WHERE R.Numquest = L.Numquest AND L.Cdrep = R.Cdrep AND E.Numind = R.Numind AND R.Numquest=3 GROUP BY L.Lbreponse;

SELECT R.Numquest, Q.Lbquest, S.Lbsexe, R.Cdrep, L.Lbreponse, Count(R.Cdrep) AS "Effectif" FROM LIBELLE_SEXE S,ECHANTILLON E,QUESTION Q,LIBELLE_REPONSE L, REPONSE R WHERE R.Numquest = L.Numquest AND L.Cdrep = R.Cdrep AND Q.Numquest = L.Numquest AND Q.Numquest = R.Numquest AND E.Numind = R.Numind AND S.Sexe = E.Sexe AND Q.Numquest=2 GROUP BY R.Numquest, Q.Lbquest, S.Lbsexe, R.Cdrep, L.Lbreponse ORDER BY S.Lbsexe, R.Cdrep;

SELECT L.Lbreponse, L1.Lbreponse, count(*) AS "Effectif" FROM REPONSE R, REPONSE R1, LIBELLE_REPONSE L, LIBELLE_REPONSE L1 WHERE R.Numind = R1.Numind AND R.Numquest = L.Numquest AND R.Cdrep = L.Cdrep AND R1.Numquest = L1.Numquest AND R1.Cdrep = L1.Cdrep AND R.Numquest=2 AND R1.Numquest=4 GROUP BY L.Lbreponse, L1.Lbreponse;

SELECT E.Sexe, E.Age, Count(*) AS "Effectif" FROM ECHANTILLON E GROUP BY E.Sexe, E.Age;

SELECT R.Numquest, S.Lbsexe, Count(*) AS "Effectif" FROM ECHANTILLON E, REPONSE R, LIBELLE_REPONSE L, LIBELLE_SEXE S WHERE L.Numquest=R.Numquest AND L.Cdrep=R.Cdrep AND R.Numind=E.Numind AND E.Sexe=S.Sexe AND L.Lbreponse="Non-Réponse" GROUP BY R.Numquest, S.Lbsexe ORDER BY R.Numquest;