Write the SQL to return all of the rows in the artists table?
Write the SQL to select the artist with the name "Black Sabbath"
Write the SQL to create a table named 'fans' with an autoincrementing ID that's a primary key and a name field of type text
Write the SQL to alter the fans table to have a artist_id column type integer?
Write the SQL to add yourself as a fan of the Postal Service? ArtistId 174
Write the SQL to return fans that are not fans of the black eyed peas.
Write the SQL to display an artists name next to their album title
Write the SQL to display artist name, album name and number of tracks on that album
Write the SQL to return the name of all of the artists in the 'Pop' Genre
BONUS (very hard)
I want to return the names of the artists and their number of rock tracks
who play Rock music
and have more than 30 tracks
in order of the number of rock tracks that they have
from greatest to least