Navigation Menu

Skip to content

Instantly share code, notes, and snippets.

@codecademydev

codecademydev/welp.sqlite Secret

Created February 13, 2022 11:07
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save codecademydev/96f0e504ba812a0df99fb7151e8f1974 to your computer and use it in GitHub Desktop.
Save codecademydev/96f0e504ba812a0df99fb7151e8f1974 to your computer and use it in GitHub Desktop.
Download ZIP
Codecademy export
Raw
welp.sqlite
WITH table1 AS (SELECT id,
username,
place_id,
review_date,
rating,
note
FROM reviews
WHERE strftime("%Y", review_date) = "2020")
SELECT *
FROM places
JOIN table1
ON places.id = reviews.place_id;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment