Answered step by step
Verified Expert Solution
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
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