FAQ: Why Learn SQL? - Creating Usage Funnels

#1

This community-built FAQ covers the “Creating Usage Funnels” exercise from the lesson “Why Learn SQL?”.

Paths and Courses
This exercise can be found in the following Codecademy content:

Web Development

FAQs on the exercise Creating Usage Funnels

Join the Discussion. Help a fellow learner on their journey.

Ask or answer a question about this exercise by clicking reply (reply) below!

Agree with a comment or answer? Like (like) to up-vote the contribution!

Need broader help or resources? Head here.

Looking for motivation to keep learning? Join our wider discussions.

Learn more about how to use this guide.

Found a bug? Report it!

Have a question about your account or billing? Reach out to our customer support team!

None of the above? Find out where to ask other questions here!

#2

Why isn’t the full table name typed out? In the example code just the single letter ‘c’ is used for the ‘checkout’ table. If I have multiple tables that start with the letter ‘c’ will I have a problem?
SELECT ROUND(
100.0 * COUNT(DISTINCT c.user_id) /
COUNT(DISTINCT b.user_id)
) AS browse_to_checkout_percent,
ROUND(
100.0 * COUNT(DISTINCT p.user_id) /
COUNT(DISTINCT c.user_id)
) AS checkout_to_purchase_percent
FROM browse b
LEFT JOIN checkout c
ON b.user_id = c.user_id
LEFT JOIN purchase p
ON c.user_id = p.user_id;