Music Explorer!

Click arrow on right of page to begin :)

Question 1

Find all albums with the word "best" in their name - what is the name of the classical musician who appears in these results?

Submit

Question 2

Count the total number of albums

Submit

Question 3

Order the artists whose name starts with "The" alphabetically - what is the name of the first artist that DOESN'T have a number in their name?

Submit

Question 4

Count the number of different cities customers are from

Submit

Question 5

Find the customer with the phone number +453 3331 9991 - take their full name

Submit

Question 6

Find all customers from India - take the initials of the first person

Submit

Question 7

Find all the customers with yahoo or gmail email addresses - take the first person's email

Submit

Question 8

Find the customers who work for Google Inc - take the city the first person lives in

Submit

Question 9

Find all the artists with the word "Orchestra" and "Sir" in their name - how many are there?

Submit

Question 10

Get the employees hired in 2003 - what month number (i.e. 1-12) was the earliest hire in 2003?

Submit

Question 11

Sum the total cost of all invoices

Submit

Question 12

Find the average invoice amount to 2 decimal places of German buyers

Submit

Question 13

Find all invoice and customer details for the customer with an ID of 33 - what is their first name and highest total spend. Separate your answer with a comma

Submit

Question 14

Find the playlist names that the track with an ID of 190 is included in - what decade (50s, 60s, 70s etc) can you conclude that track is from?

Submit

Question 15

Find the difference in duration between the longest and shortest track

Submit

Question 16

Show the genre name, with the number of tracks, ordered from the genre with the most tracks to the least - what genre has the most tracks and how many does it have? Separate your answer with a comma

Submit

Question 17

Find the name of the album and singer of all songs from the 'Soundtrack' genre - what year can we see most were written for?

Submit

Question 18

Get the full name of the most popular file format

Submit

Question 19

Get the artist name who produced the album "War"

Submit

Question 20

Get the first name, last name and total spent for the customer who spent the most money - separate your answer with a space or comma

Submit

Congratulations...you made it!