B423_queries.sql

# Customer list

SELECT first_name, last_name, email FROM customers
ORDER BY last_name



# Classical Playlist

SELECT tracks.name, tracks.composer FROM playlist_tracks
JOIN tracks ON tracks.id = playlist_tracks.track_id
JOIN playlists ON playlists.id = playlist_tracks.playlist_id
WHERE playlists.name = "Classical"



# Top 10 artists in Playlists

SELECT artists.name, COUNT(*) AS occurances FROM artists
JOIN albums ON albums.artist_id = artists.id
JOIN tracks ON tracks.album_id = albums.id
JOIN playlist_tracks ON playlist_tracks.track_id = tracks.id
GROUP BY artists.name
ORDER BY occurances DESC
LIMIT 10