Yurttas/PL/DBL/mssql/F/01/Movies/q05.sql

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