FROM Movie AS Old
WHERE year < ANY
WHERE title = Old.title);
Movie (title, year, director, length)
Movie titles are not unique (titles may reappear in a later year).
Find movies whose title appears more than once.
Note scope of variables
Back to first slide
View graphic version