Question
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
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 CauntryNameStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started