CS50 Movies - CS 50 Problem Set 7 -Movies Solution 2024. (Beginners Guide)

UPDATE: 17:30 - looks like CS50 updated SQL 12 from Johnny Depp and HBC to Bradley Cooper and Law. Make sure to update the sql accordingly - same code - just update the names. Let me know team if you find any other changes. SELECT m.title FROM movies m JOIN stars s ON m.id = s.movie_id JOIN people p ON s.person_id = p.id WHERE p.name IN ('Bradley Cooper', 'Jennifer Lawrence') GROUP BY m. title HAVING COUNT(DISTINCT p.name) = 2;