Connected to: Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production With the Partitioning and Java options PL/SQL Release 8.1.5.0.0 - Production SQL> CREATE VIEW employedActors AS ( SELECT name, website, seriesTitle, seriesCreator FROM actors, plays WHERE plays.actorName = actors.name ); 2 3 4 5 View created. SQL> select name, seriesTitle from employedActors ORDER BY name; NAME -------------------------------------------------------------------------------- SERIESTITLE -------------------------------------------------------------------------------- Denise Crosby Star Trek: The Next Generation Gates McFadden Star Trek: The Next Generation Jonathan Frakes Star Trek: The Next Generation NAME -------------------------------------------------------------------------------- SERIESTITLE -------------------------------------------------------------------------------- Marina Sirtis Star Trek: The Next Generation Michael Dorn Star Trek: The Next Generation Patrick Stewart Star Trek: The Next Generation NAME -------------------------------------------------------------------------------- SERIESTITLE -------------------------------------------------------------------------------- Whoopi Goldberg Star Trek: The Next Generation Wil Wheaton Star Trek: The Next Generation 8 rows selected. SQL> CREATE VIEW picardEpisodes AS ( SELECT episodes.* from episodes, featuring WHERE episodes.title = featuring.episodeTitle AND episodes.seriesTitle = featuring.seriesTitle AND episodes.seriesCreator = featuring.seriesCreator AND featuring.seriesCreator = 'Gene Roddenberry' AND featuring.seriesTitle = 'Star Trek: The Next Generation' AND featuring.characterName = 'Jean-Luc Picard' ); 2 3 4 5 6 7 8 9 View created. SQL> select avg(quality) from picardEpisodes; AVG(QUALITY) ------------ 6.66666667 SQL> exit Disconnected from Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production With the Partitioning and Java options PL/SQL Release 8.1.5.0.0 - Production 12:36am elaine14:~/cs145/hw6>