Yurttas/PL/DBL/oracle/F/01/Movie/q05.sql
Jump to navigation
Jump to search
1REM
2REM q05.sql
3REM
4REM Which stars appeared in movies produced by
5REM 'Disney' studios in 1997 but not in 1998
6REM 'Disney' movies.
7REM
8
9SELECT SI.name
10FROM Movie M, StarsIn SI
11WHERE M.year = 1997
12 AND M.studioname = 'Disney'
13 AND M.title = SI.title
14 AND SI.name NOT IN (SELECT SI.name
15 FROM Movie M, StarsIn SI
16 WHERE M.year = 1998
17 AND M.studioname = 'Disney'
18 AND M.title = SI.title);