Skip to content

Instantly share code, notes, and snippets.

@codecademydev

codecademydev/welp.sqlite Secret

Created Dec 9, 2020
Embed
What would you like to do?
Codecademy export
with reviews20 as (
select *
from reviews
where strftime("%Y", review_date) = 2020
)
select *
from reviews20
join places
on reviews20.place_id = places.id;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment