diff options
| author | Fudgerboy <91767657+Fudgerboy@users.noreply.github.com> | 2024-05-21 05:09:21 +0000 |
|---|---|---|
| committer | Fudgerboy <91767657+Fudgerboy@users.noreply.github.com> | 2024-05-21 05:09:21 +0000 |
| commit | 908447c2860c3987b9bd1416f2eeb33c7fe3b37f (patch) | |
| tree | b21304b384706d6d844cdd74c66c4a2a6bf11239 /wk7/pset/movies | |
| parent | 7b9b1e93334d1ce9dea98841bc9e2977ae893fea (diff) | |
Mon, May 20, 2024, 10:09 PM -07:00
Diffstat (limited to 'wk7/pset/movies')
| -rw-r--r-- | wk7/pset/movies/13.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/wk7/pset/movies/13.sql b/wk7/pset/movies/13.sql index 5d4f0e8..54a3116 100644 --- a/wk7/pset/movies/13.sql +++ b/wk7/pset/movies/13.sql @@ -1,9 +1,9 @@ -SELECT Count(*) +SELECT name FROM people WHERE id IN ( SELECT person_id FROM stars - WHERE movie_id = ( + WHERE movie_id IN ( SELECT movie_id FROM stars WHERE person_id = ( |