Applications of Databases to Humanities and Social Sciences

Sociology : Answer 1

Display the number of individuals having answered, in the same survey : 1 at the question 1 , 2 at the question 2 and 3 at the question 3.

Links between tables

SQL query

(Back to questions)

Sociology : Answer 2

Display which is (on average), the number of brothers and sisters of an individual according to the profession of the father of this individual. We shall suppose that the profession of the father is the question number 3 of the survey.

Links between tables

SQL query

(Back to questions)

Sociology : Answer 3

Make a frequency distribution on the question number 2, divided up by sex of the individuals.

Links between tables

SQL query

(Back to questions)
 

Sociology : Answer 4

Make a bivariate frequency table between questions number 2 and 4.

Links between tables

SQL query

(Back to questions)

Sociology : Answer 5

Display the distribution, by sex and age, of the population.

Links between tables

SQL query

(Back to questions)

Sociology : Answer 6

Display the distribution ,by sex and number of question, for the individuals who did not answer to a question : wording of the answer is equal to "Non-Réponse".

Links between tables

SQL query

(Back to questions)

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