John Adams is the artist

$1.$ What SQL would select an artist that is not in the database? $($Hint: Try different artists until the query returns zero rows.$$ You will insert this artist in Question $2)$ SELECT count$(*)$ from artists WHERE name $=""$

$2.$ What SQL would INSERT the artist?

$3.$ What SQL would INSERT an album for the artist?$($Hint: You will need to find the ArtistId that you just added.$)$

$$ Show your successful execution of the SQL

$$

$4.$ What SQL would INSERT multiple tracks for the album? $($Hint: You will need to find the AlbumId that you just added.$)$

$$ Show your successful execution of the SQL

$$

$5.$ What SQL would select the tracks you just added?

$$ Show your successful execution of the SQL

$$

$6.$ What SQL would select the largest track file size "MAX $($Bytes$)"$ that you just added?

$$ Show your successful execution of the SQL

$$

$7.$ What SQL would select the number of seconds, it would take you to listen to all of the songs on the album you just added?$($Hint: SELECT SUM $($milliseconds$)/1000$ as seconds.$)$

$$ Show your successful execution of the SQL

$$

$8.$ What SQL would select the number of albums each artist has WHERE the artist name begins with the letter $$R$?$ Only return artists that have more than $1$ album.

$$ Show your successful execution of the SQL

$$

$9.$ What SQL would select all the album titles and the aggregate track data $($maximum milliseconds, minimum milliseconds, average milliseconds$)?$ Group your results by album title.

$$ Show your successful execution of the SQL

$$

$10.$ What SQL would select the total time in milliseconds and total bytes for each album title?

$$ Show your successful execution of the SQL

$$

$$

$$

$$