FAQ: Why Data Science? - Exploring Data with SQL - Continued

This community-built FAQ covers the “Exploring Data with SQL - Continued” exercise from the lesson “Why Data Science?”.

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

Data Science

FAQs on the exercise Exploring Data with SQL - Continued

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!

how much time it takes to load “pro users” query in SQL third exercise? It’s taking hours for me and I don’t know if this is normal.

Is there something I have to do to keep the lesson? It only says I have to click “run” buttom.

1 Like

Why not use the variables in the calculations rather than extract the values again?

No, it took me like three seconds to run the data. It must be your internet problem.

There is nothing in the instructions to tell me what to run in the code editor, nor is there anything there. The subsequent exercises aren’t working either. I’ve logged out and back in. I’ve restarted the program, but nothing is working. Does anyone know what I’m doing wrong? I feel like I’m getting nothing out of this, and wasting a ton of time. Please help!

Thanks :slight_smile:

Try closing your current browser, and start a new Chrome window to launch Codecademy for your lesson. I’ve seen this before, restarting the same lesson in a new Chrome browser fixed it.

1 Like

I switched to Chrome, and that solved the error. Thanks!

I was using Chrome, and it was working perfect until now. I cannot see the result from the query :frowning:
I did everything I could, and still can’t see it.

Why are they not explaining what the code does?? :frowning: will they do it later?


This looks wrong. If this wants the churn rate in march I think the end of the query should be

(cancel_date IS NULL) OR
(cancel_date >= '2017-03-01')


NOT cancel_date > ‘2017-03-01’. This would exclude where cancel_date = ‘2017-03-01’ which is valid. Am I right?

what is strftime in this code and what does %m denotes?

Can anyone explain the syntax of this example where Catherine analyzes churn rate for March 2017?

Please can someone explain what the code means?