summaryrefslogtreecommitdiff
path: root/wk7/pset
diff options
context:
space:
mode:
authorFudgerboy <91767657+Fudgerboy@users.noreply.github.com>2024-05-21 05:07:17 +0000
committerFudgerboy <91767657+Fudgerboy@users.noreply.github.com>2024-05-21 05:07:17 +0000
commit7b9b1e93334d1ce9dea98841bc9e2977ae893fea (patch)
tree4e075c53e7ed30afceec9f12082f13fb6e6120cc /wk7/pset
parent409c933af61e2e4f7c75a3aaf067f53b483fbbff (diff)
Mon, May 20, 2024, 10:07 PM -07:00
Diffstat (limited to 'wk7/pset')
-rw-r--r--wk7/pset/movies/13.sql4
1 files changed, 2 insertions, 2 deletions
diff --git a/wk7/pset/movies/13.sql b/wk7/pset/movies/13.sql
index 36f72b6..5d4f0e8 100644
--- a/wk7/pset/movies/13.sql
+++ b/wk7/pset/movies/13.sql
@@ -1,4 +1,4 @@
-SELECT name
+SELECT Count(*)
FROM people
WHERE id IN (
SELECT person_id
@@ -14,5 +14,5 @@ WHERE id IN (
)
)
)
-AND NOT name = "Kevin Bacon"
+AND name != "Kevin Bacon"
;