Matt Purnell

Write 4 queries with different subqueries

Query 1

• December 7, 2017 at 4:02 AM
• Visible to public

SELECT title FROM movies
WHERE movieid IN
(SELECT movieid FROM credits
INNER JOIN people USING(peopleid)
WHERE died - born < 30)
ORDER BY title;