How do Inner Joins 4/10


#1

how do Inner Joins 4/10


#2

Post a link to the lesson, your errors, and your code?


#3

Link to the problem:

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

I am having issues specifically with step 3:
“Join newspaper and online on id (the unique ID of the subscriber).
How many rows are in this table?”

Code that doesn’t work:

SELECT COUNT (*)
FROM newspaper
JOIN online
ON newspaper.id = online.id;

Error that I get: Did you remember to count all rows of online joined with newspaper?

I don’t understand why this is wrong. The hint is exactly the same as what I entered but it doesn’t work. If I understand the steps right, it should be correct.