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
