Write the following subquery without any subqueries SELECT t
Write the following subquery without any subqueries:
SELECT title
 FROM Movies Old
 Where year < ANY
 (SELECT year
   FROM Movies
   WHERE title = Old. title
   );
(note: this comes from the relation Movies(title, year, length, genre, studioName, producerC#))
Solution
 SELECT title
 FROM Movies Old
 Where year < ANY
 (SELECT year
 FROM Movies
 WHERE title = Old. title
 );
Answer:
    SELECT title
    FROM Movies m, Movies Old
    Where m.year < Old.year and m.title = Old. title

