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
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.
Quick I DESKTOP-5MH2FDASOLEXPRESS.Movies-Diagram - Micresoft SOL Server Manegement Studic File Edit View Project Debug Table Designer Database Disgram Tools Window Help Object Explorer SQLQuery2sql-D..MH2FDadmin (53)* QLQuery1sal-not connected tblFilmCopy FilmID DESKTOP 55 (5QL Server 13.0.5026 tblActorCopy ActorlD -System Databases Database Snapahots ActerDCB DD bookstore ActorGender Movies tblActor Database Diagrams System Tables External Tebles tblStudio StudiolD tblFilm FilmD Tables 1 FileTebles FilmRunTimeMinutes FilmCertdicate D tblLanguage LanguagelD E dba.tblCountry FilmRun TimeMinutes tblDirector V DirectorD Extemal Resources Synonyms tblCertificate Programmability Serice Broker Storage Security FilmOscarWins CertficateD CertficateName Security Server Objects tblCountry CountrylDStep 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