In step 2, you create the quiz funnel; then, Codecademy asks you to use an external spreadsheet program to calculate % of passage from stage to stage of the funnel. But is it possible to do in SQL if all questions and responses to the quiz are stored in the same table?
SELECT question, COUNT(user_id) AS '# of users', 1.0 * COUNT(question = "1. What are you looking for?") / COUNT(response) * 100 AS '1st step passage %' FROM survey GROUP BY question ORDER BY user_id;
Please help find out