I’m currently working through a problem and which requires me to create a with statement in order to use a strtftime() calculation and I am having trouble finding where I went wrong!
Sometimes on Welp, there are some old reviews that aren’t useful anymore.
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 old_review as
where strftime("%Y", review_date) = review_date
on places.id = reviews.place_id
where old_review = 2020;