Hi guys, I am new to this and having trouble in understanding what how to figure out this question.
Here is the link if anyone can explain the answer to me that would be awesome. I believe, using the hint, I’m supposed to put “NULL”, but am unsure. any help would be appreciated.
Please post the code you’ve written so far.
(and yes, you’re correct–you have to use
NULL for the places that don’t have any reviews).
Hey, I am also stuck on this one. Came up with the solution I posted below but not sure if it is the correct way, Would appreciate it a lot if someone could confirm
WITH reviews_2020 AS (
WHERE strftime(“%Y”, review_date) = ‘2000’
LEFT JOIN reviews_2020 ON places.id = reviews_2020.place_id;
I think you meant ‘= 2020’
Might want to double check that
JOIN clause. If I’m not mistaken, that should be something like:
JOIN reviews2020 ON
reviews2020.place_id = places.id;