Yurttas/PL/DBL/oracle/F/01/Movie/q05.sql

 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);