Learning MySQL

Exercises

All exercises here concern the music database. You’ll find the table structures in The Music Database” are a useful reference, or you can practice using the SHOW statement as you work your way through the tasks:

1. Use one or more SELECT statements to find out how many tracks are on New Order’s Brotherhood album.

2. Using a join, list the albums that we own by the band New Order.

3. With INSERT statements, add the artist Leftfield to the database. For this new artist, add the album Leftism that has the following tracks:

   1. Release the Pressure (Time: 7.39)

   2. Afro-Melt (Time: 7.33)

   3. Melt (Time: 5.21)

   4. Song of Life (Time: 6.55)

   5. Original (Time: 6.00)

   6. Black Flute (Time: 3.46)

   7. Space Shanty (Time: 7.15)

   8. Inspection Check One (Time: 6.30)

   9. Storm 3000 (Time: 5.44)

   10. Open Up (Time: 6.52)

   11. 21st Century Poem (Time: 5.42)

   12. Bonus Track (Time: 1.22)

4. How long in minutes is the Leftism album you added in Question 3? Hint: use the SUM() aggregate function.

5. Change the time for the Original track on the Leftism album to 6.22.

6. Remove the Bonus Track from the Leftism album.