Yurttas/PL/DBL/mysql-f-2010/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
11\. set-db.sql
12
13SELECT SI.name
14FROM Movie M, StarsIn SI
15WHERE M.year = 1997
16  AND M.studioname = 'Disney'
17  AND M.title = SI.title
18  AND SI.name NOT IN (SELECT SI.name
19                      FROM Movie M, StarsIn SI
20                      WHERE M.year = 1998
21                        AND M.studioname = 'Disney'
22                        AND M.title = SI.title);