Using the Chinook database, implement the following SQL queries:

1.

List the names of each playlist and the number of tracks on that playlist. Your output columns should be listed

as PlaylistName and NumTracks in that order; note that you will need to alias the columns to achieve this.

2.

st the 50-100 most-purchased tracks; count the number of purchases by looking at how

many invoice lines a track matches with. Your output columns should be listed as

TrackName and NumPurchases in that order; note that you will need to alias the columns to achieve this.

3.

List those artists who have three or more songs that are 100000 ms or shorter in length. Your

output columns should be listed as ArtistName and NumSongs in that order; note that you

will need to alias the columns to achieve this.

4.

List artists who have five or more albums that are at least 2500000 ms long (i.e., the total of

all the tracks on the album is at least 2500000 ms). Your output columns should be listed

as ArtistName and NumAlbums in that order; note that you will need to alias the columns to achieve this.

5.

t the names and total number of albums of artists who had more albums than the Foo Fighters.

Your output columns should be listed as ArtistName and NumAlbums in that order;

note that you will need to alias the columns to achieve this.