Question
Practice SQL Joins. Use the Movies database we created last week. For all result sets, make sure the column names are human-readable, you only have
Practice SQL Joins. Use the Movies database we created last week. For all result sets, make sure the column names are human-readable, you only have the information in the result set in which a human would be interested. Turn in 1 worksheet (Excel or Google Sheets) that includes a spreadsheet per result set, so a total of 4 spreadsheets in 1 worksheet and 1 .sql file with all of your SQL statements. 1. Write a statement joining all tables to produce a result set that has all the information a human would want to know about all of the movies in the database. Export that information to a Spreadsheet. 2. Write a statement that will produce a result set that displays actor names and shows the films that they have been in. Export this to a spreadsheet. 3. Write a statement that will produce a result set of directors who don't have a movie listed in the database. Export this to a spreadsheet. 4. Write a statement that will produce a result set of the studios that don't have a movie listed in the database. Export this to a spreadsheet.
Database Movies - https://ufile.io/i73jg
tblDirector DirectorlD DirectorDO8 tblCast 9 Cast D CastCharacterName FilmCountrylD FilmStudiolD tblLanquage tblActor Language D LanguageName FilmRunTimeMinutes FilmBoxOfficeDollars FilmOscarNo minations tblCertificate CertificateName tblStudio tblCountry Country D Country Name StudioNameStep 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