Multiple tables quiz 5 q2

[sunnychung]

MULTIPLE TABLES QUIZ 5 Q2.

In order to find which users do not subscribe to the online edition, we need to add a WHERE clause. Create a new query that adds the following WHERE clause:

WHERE online.id IS NULL

This will select rows where there was no corresponding row from the online table.

Can everyone give me the answer?

[brandnew_12]

Simply write the statement after the the JOIN… ON part.

It would look like this:

Code

SELECT *
FROM newspaper
LEFT JOIN online
ON newspaper.id = online.id
WHERE online.id IS NULL;

[sunnychung]

Thanks.
But I tried, It didn’t work.
As the picture shown:

[brandnew_12]

Uhm, maybe it’s a bug. At this point you might want to reset the exercise, and try all over again. I posted the solution below if that doesn’t help.

Solution

– First query
SELECT *
FROM newspaper
LEFT JOIN online
ON newspaper.id = online.id;

– Second query
SELECT *
FROM newspaper
LEFT JOIN online
ON newspaper.id = online.id
WHERE online.id IS NULL;