Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

image text in transcribed

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 CountrylD

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

recognise typical interviewer errors and explain how to avoid them

Answered: 1 week ago

Question

identify and evaluate a range of recruitment and selection methods

Answered: 1 week ago

Question

understand the role of competencies and a competency framework

Answered: 1 week ago