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!