PART 1

Design the following queries. Save the queries in a txt file, and submit it in to Canvas.

Q1: List the artistname and entrydate of the artist with the earliest entry date.

Q2: List the track titles of all titles in the 'alternative' genre.

Q3: List all genres from the Genre table that are not represented in the Titles table.

Q4: List the track title with longest length in seconds.

Q5: List length of the longest RealAud track in the 'metal' genre

Q6*: List track titles and lengths of tracks with a length longer than all tracks of the 'metal' genre.

(Hint: This requires sub-query within a sub-query)

PART 2

Equi-join and Inner join: (you are free to choose anyone of the two kinds of joins)

Q7: List the CD title and the title of all tracks recorded in StudioID 1

Q8: List each title from the Title table along with the name of the studio where it was recorded.

Q9: Find the name of the sales person who works with the member with last name 'Alvarez'

Q10: List name of members from California (CA) and their salespeople.

Q11: List the names of all artists who have recorded more than one titles and the number of titles they have.

Q12: Report the name of the title and number of tracks for any title that have fewer than 9 tracks.

spesifcally number 12.