Matt Purnell

Write 4 queries with different subqueries

Query 4

December 7, 2017 at 4:04 AM
Visible to public

SELECT first_name 'First Name, surname 'Last Name', m.title 'Movie', m.year_released-born 'Age at release' FROM people p
LEFT JOIN
(SELECT * FROM movies m
INNER JOIN credits
ON m.movieid = c.movieid
WHERE p.born < m.year_released) c
ON c.peopleid = p.peopleid
WHERE c.credited_as = 'A'
ORDER BY m.year_released-born asc;