So I am working on the bonus practice for joining multiple tables. I have come to the question about the WELP reviews and I have been staring at it forever I feel like, I’m fairly new to Codecademy so was hesitant to ask for help but seems like my best option. I’m sure it’s something small I’m missing so please no judgement :).
So the following is the question and following that is the query I’m trying to use. So I’ve studied the tables multiple times but when I run the basic query with the WITH and STRFTIME but it returns no results. Like I said, I’m sure it’s something minor that I’m overlooking but I could really use some advice. Thanks so much .
Write a query using the
WITH clause to select all the reviews that happened in 2020.
places to your
WITH query to see a log of all reviews from 2020.
(This will use the
WITH clause as well as the
strftime() function. See if you can use Google to dig up some information about the function before take a look at the hint.)
WITH reviews_2020 AS (
WHERE strftime("%Y", review_date) = ‘2020’