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

Write the following subquery without any subqueries: SELECT title FROM Movies Old Where year < ANY (SELECT year FROM Movies WHERE title = Old. title ); (note

Get Help Now

Submit a Take Down Notice

Tutor
Tutor: Dr Jack
Most rated tutor on our site