Learn
Mattresses and More users were asked to answer a five-question survey:
- “How likely are you to recommend Mattresses and More to a friend?”
- “Which Mattresses and More location do you shop at?”
- “How old are you?”
- “What is your gender?”
- “What is your annual household income?”
However, not every user finished the survey!
We want to build a funnel to analyze if certain questions prompted users to stop working on the survey.
We will be using a table called survey_responses
with the following columns:
question_text
- the survey questionuser_id
- the user identifierresponse
- the user answer
Instructions
1.
Start by getting a feel for the survey_responses
table.
Select all columns for the first 10 records from survey_responses
.
2.
Delete your previous query.
Let’s build our first basic funnel!
Count the number of distinct user_id
who answered each question_text
.
You can do this by using a simple GROUP BY
command.
What is the number of responses for each question?
Sign up to start coding
By signing up for Codecademy, you agree to Codecademy's Terms of Service & Privacy Policy.