Psychology: Answers

Psychology : Answer 1

Display the name, age, gender and professional category of the "Leader" of the group: the one that has the maximum affinity. 

Links between tables

Diagram of data for Database Psychology question 1

SQL query

(Back to questions)

 Psychology: Answer 2

Show the leader's score and gender distribution. This question can be useful, for example, to check the "weight" of the variable sex in the score obtained by the leader. 

Links between tables

Diagram of data for Database Psychology question 2

SQL query

(Back to questions)

 Psychology: Answer 3

List the "groups" of 2 individuals of the same gender, the most homogeneous in terms of the respective affinity of the individuals. 

Links between tables

Diagram of data for Database Psychology question 3

SQL query

(Back to questions)

 Psychology: Answer 4

List the most homogenous male groups of 3 individuals, according to the respective affinity of the individuals.

Links between tables

Diagram of data for Database Psychology question 4

SQL query

(Back to questions)

Psychology : Answer 5

Display the list of professional categories with an average score greater than 8.

Links between tables

Diagram of data for Database Psychology question 5

SQL query

(Back to questions)