Search the web

Readir

zy Section $4\mathrm{.}2-$ BIS $245$ :

zy Section $4\mathrm{.}1-$ BIS $245$:

$x$

devry: Customer Sen

$x$

devry: Customer Serv

How to Overcome C

learn.zybooks.com$/$zybook$/$Database$\_$Essentials$\_$for$\_$Business$\_$with$\_$Lab$\_\_\_11506/$chapter$/4/$section$/2$

My library $>$ BIS $245$: Database Essentials for Business with Lab home $>4\mathrm{.}2$ : Join queries

zyBooks catalog

$(?)$ Help

PARTICIPATION

ACTIVITY

$4\mathrm{.}2\mathrm{.}9.$ Join coding exercise

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.

$1$ CREATE TABLE Genre $($

$2$ Code CHAR$(3),$