4. Inner joins step 1. Counting newspaper subscribers


#1

I’m working on Lesson 4. Inner Joins. Step 1 says to: Count the number of subscribers who get a print newspaper. Am I not already accomplishing that task with the first count() function below?
:

SELECT COUNT(*)
FROM newspaper;

select count(*)
from online;

select *
from newspaper
join ON newspaper.id = online.id

Submitting the above code yields the result:

Did you remember to count all rows of newspaper?

Url to lesson:
https://www.codecademy.com/courses/learn-sql-multiple-tables/lessons/multiple-tables/exercises/inner-join-ii?action=resume_content_item&course_redirect=learn-sql


#2

Link to exercise please. Copy the URL in the location bar and paste it into your opening post, or in a reply.


#3

Original post has been edited with the URL, thanks


#4

This worked for me, in terms of displaying as expected. I did not reset the lesson so cannot say if it will still pass, but it did at the time I did this exercise a couple years ago.

select count(*) from newspaper;
select count(*) from online;

SELECT newspaper.id, online.last_name
FROM newspaper JOIN online
ON newspaper.id = online.id;

#5

This also does not allow me to proceed. I’m still getting the message: Did you remember to count all rows of newspaper?


#6

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.