Steps:

$1)$ Write a query that JOINS two tables and uses a subquery to list the songs made by artists

over the age of $50.$ Your query should show the name of the song, the name of the artist, the

song length, and release date. For the column headers in the output rename $$song$\_$name$$ to

$$Title$,$artist$$ to $$Artist$,$duration$$ to $$Length$,$ and $$release$\_$date$$ to $$Release Year$$

Your output should look like this

Title Artist Length Release Year

Where Does My Heart Beat

Now Celine Dion $4\mathrm{.}331990$

The Last to Know Celine Dion $4\mathrm{.}361990$

Have a Heart Celine Dion $4\mathrm{.}161991$

Candle in the Wind $1997$ Elton John $3\mathrm{.}591997$

All I want for Christmas Is You Mariah Carey $4\mathrm{.}011994$

La Voce Del Silenzio Andrea Bocelli $4\mathrm{.}552007$

Just the Two of Us Will Smith $5\mathrm{.}151997$

$2)$ Write a query that JOINS all tables created in the previous lab to display the data in a similar

format to music$\_$basic. When you are joining your tables ensure that you are joining records with

valid albums, artists, and genres. $($Only matching rows$)$

NOTE: You are not using the music$\_$basic table, but rather JOINing the artists, genre, album,

and songs tables to output a table in the same format. Modify your column headers to produce a

readable table that looks like this:

$($Hint: SELECT $*$ FROM music$\_$basic to get an idea for how your output should look. There are

multiple ways to do this!$)$

Id Title Artist Genre Length Release Year Album

$1$

Where Does

My Heart

Beat Now

Celine Dion Pop $4\mathrm{.}331990$ Unison

$2$ The Last to

Know Celine Dion Pop $4\mathrm{.}361990$ Unison

$4$ Call Me

Maybe Katy Perry Pop $3\mathrm{.}132011$ Now $27$

$5$ Have a

Heart Celine Dion Pop $4\mathrm{.}161991$ Unison

$............................$

$3)$ Create a View table using the query created in Question $2.$ Display the contents of the view

table and include the results in your screenshot.