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.