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
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;