RETURN;

--Homework #3a Querying Multiple Tables --Your Name:

/*-------------------------------------------------------------------------------------- Instructions:

If you haven't done so in class, please download and run the entire syntax in the MovieDatabase.sql file to establish a Movies database. Answer the following questions as best as possible. Show your work if you need to take multiple steps to answer a problem. Partial answers will count. --------------------------------------------------------------------------------------*/

/*Q1. (0.5 point) List Film Name, Director Name, Studio Name, and Country Name of all films.*/

/*Q1. Syntax*/

/*Q2. (0.5 point) List people who have been actors but not directors.*/

/*Q2. Syntax*/

/*Q3. (1 point) List actors that have never been directors and directors that have never been actors.*/

/*Q3. Syntax*/

/*Q4. (1 point) List all films that are released in the same year when the film Casino is released.*/

/*Q4. Syntax*/

/*Q5. (0.5 point) Using JOIN to list films whose directors were born between '1946-01-01' AND '1946-12-31'. */

/*Q5. Syntax*/

/*Q6. (0.5 point) Using subquery to list films whose directors were born between '1946-01-01' AND '1946-12-31'. */

/*Q6. Syntax*/

tblCertificate 8 Certifica 1D Cerfifica te Name tblCast Cast D CastCharacterName tblilm 9 FimD Fim ReeaseDate Film DiectonD tblStudio 9 StudioD 9 ActorlD ActorName StudioName Fim RunTimeMinute Dolars FimBxOffceDollars FimOscarNominstion tblDirector DirectorD tblL 8 LanguagelD tblCountr CountrylD LanguageName CauntryName