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

 1/*
 2REM
 3REM q04.sql
 4REM
 5REM Find the names and addresses of movie stars
 6REM of movies produced by 'Steven Spielberg'.
 7REM
 8*/
 9
10SELECT MS.name, MS.address
11FROM MovieStar MS, MovieExec ME, Movie M, StarsIn SI
12WHERE ME.name = 'Steven Spielberg'
13  AND ME.cn = M.producercn
14  AND M.title = SI.title
15  AND SI.name = MS.name;