Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The SQL below creates Genre and Song tables, inserts some genres and songs, and performs an inner join. Run the SQL. Verify the result table

The SQL below creates Genre and Song tables, inserts some genres and songs, and performs an inner join. Run the SQL. Verify the result table does not include songs with NULL genre or genres that are not associated with songs. Make the following changes: In the CREATE TABLE statement for Song, rename GenreCode to Code. Modify the SELECT statement to work with the new name. Run the SQL and verify the result table is unchanged. Modify the SELECT statement to perform a left join. Run the SQL and verify the result table includes songs with NULL genre. Modify the SELECT statement to perform a right join. Run the SQL and verify the result table includes genres that are not associated with any songs. Combine the left and right joins into one statement that performs a full join. Run the SQL and verify the result table includes all songs and genres. Hints: In steps 2 and 3, use keywords LEFT and RIGHT. In step 4, use keyword UNION, since MySQL does not support FULL JOIN

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_2

Step: 3

blur-text-image_3

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

A Pathway To Introductory Statistics

Authors: Jay Lehmann

1st Edition

0134107179, 978-0134107172

More Books

Students also viewed these Algorithms questions

Question

1/4b3 1/2 = 9/4

Answered: 1 week ago