Matt Purnell

Write 4 queries with different subqueries

Query 2

  • December 7, 2017 at 4:03 AM
  • Visible to public 
SELECT m.title 'Main Title', a.title 'Alt Title', year_released 'Released in' FROM movies m
LEFT JOIN
(SELECT * FROM alt_titles
WHERE LENGTH(title) > 2) a
ON m.title = a.title
WHERE country = 'gb'
ORDER BY m.title;