Example #2
•
Movie(title, director, year), Oscar(title, year)
•
Query: find directors whose movies won
Oscars after 1965:
•
select m.director
•
from Movie m, Oscar o
•
where m.title=o.title AND m.year=o.year
AND
o.year > 1965
.
•
Complete or not?