summaryrefslogtreecommitdiff
path: root/wk7
diff options
context:
space:
mode:
Diffstat (limited to 'wk7')
-rw-r--r--wk7/pset/movies/11.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/wk7/pset/movies/11.sql b/wk7/pset/movies/11.sql
index e69de29..978cdcc 100644
--- a/wk7/pset/movies/11.sql
+++ b/wk7/pset/movies/11.sql
@@ -0,0 +1,7 @@
+SELECT title
+FROM movies
+JOIN ratings ON movies.id = ratings.movie_id
+JOIN people ON ratings.person_id = people.id
+WHERE name = "Chadwick Boseman"
+ORDER BY rating
+;