Applications of Databases to Humanities and Social Sciences

Psychology : Answer 1

Display the name, the age, the sex and the professional category of the "Leader" of the group : the one which collects the maximum of affinity in descending order. The first of the list is the "leader" of the group.

Links between tables

SQL query

(Back to questions)

 Psychology : Answer 2

Display, for the leader, the score that he obtained and the distribution by sex. This question can be useful, for example, to check the "weight" of the variable Sexe in the score obtained by the leader.

Links between tables

SQL query

(Back to questions)

 Psychology : Answer 3

Give the list of the "groups" of 2 individuals of the same sex, most homogeneous within the meaning of the respective affinity of the individuals.

Links between tables

SQL query

(Back to questions)

 Psychology : Answer 4

Give the list of the most homogeneous male groups of 3 individuals, within the meaning of the respective affinity of the individuals.

Links between tables

SQL query

(Back to questions)

Psychology : Answer 5

Display the list of the professional categories having an average score greater then 8.

Links between tables

SQL query

(Back to questions)

©Marc Grange, February 2001 | Last update: April 10, 2006