Matt Purnell

Write 4 queries with different subqueries

Query 3

  • December 7, 2017 at 4:03 AM
  • Visible to public 
SELECT title 'Movie', first_name 'First Name', surname 'Last Name' FROM people
LEFT JOIN
(SELECT * FROM credits
INNER JOIN movies USING(movieid)
WHERE credited_as = 'A')
USING(peopleid)
WHERE country = 'fr'
ORDER BY surname desc;