Question: 2. Simple SQL Consider the following table, representing the results of a survey asking people their age, gender and education (table name: survey_responses, see the

2. Simple SQL Consider the following table, representing the results of a survey asking people their age, gender and education (table name: survey_responses, see the attachment) And here's the key to the codes used (table name: survey_key.txt, see the attachment) Write an SQL statement that produces the following summary results (for ageband) Similarly, give the SQL statement for gender and education. Ensure your solution wouldn't change much if the survey had many more questions. 2. Simple SQL Consider the following table, representing the results of a survey asking people their age, gender and education (table name: survey_responses, see the attachment) And here's the key to the codes used (table name: survey_key.txt, see the attachment) Write an SQL statement that produces the following summary results (for ageband) Similarly, give the SQL statement for gender and education. Ensure your solution wouldn't change much if the survey had many more questions
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
