第344页 8.1.4 Exercises for Section 8.1

a)
CREATE VIEW RichExec AS
     SELECT *
     FROM MovieExec
     WHERE netWorth >= 10000000;

b)
CREATE VIEW StudioPres AS
     SELECT name, address, cert#
     FROM MovieExec, Studio
     WHERE cert# = precC#;

c)
CREATE VIEW ExecutiveStar AS
     SELECT name, address, gender, birthdate, cert#, netWorth
     FROM MovieStar, MovieExec
     WHERE MovieStar.name = MovieExec.name 
     AND MovieStar.address = MovieExec.address;

Exercise 8.1.2:
a)
SELECT name FROM ExecutiveStar WHERE gender = 'female';

b)
SELECT name
FROM RichExec, StudioPres
WHERE RichExec.cert# = StudioPres.cert#;

c)
SELECT name
FROM RichExec, StudioPres, ExecutiveStar
WHERE RichExec.cert# = StudioPres.cert# 
AND RichExec.cert# = ExecutiveStar.cert#
AND RichExec.netWorth >= 50000000;