- Install the SQLite Browser if you haven't already here
- Open the SQLite Browser and click 'File -> Open DataBase'
- Choose the
chinook.db
file from this repo. This database is open source and maintained by Microsoft (SQL is no fun if you don't have any data)
- How would you return all of the rows in the artists table?
- How would you select the artist with the name "Black Sabbath"
- How would you create a table named 'fans' with an autoincrementing ID that's a primary key and a name field of type text
- How would you alter the fans table to have a artist_id column type integer?
- How would you add yourself as a fan of the Black Eyed Peas? 169
-
Visit http://www.mess.be/inickgenwuname.php and generate a Wu-Tang name for yourself. How would you update your name to be your wu-tang name?
-
How would you return students that are not fans of the black eyed peas.
- I want to return the names of the artists and their number of rock tracks who play Rock music and have move than 30 tracks in order of the number of rock tracks that they have from greatest to least