Course
AdvancedCurious what juicy queries we've got for you this time? Be sure to check this month's challenge!
Welcome to our next SQL Practice! New tasks are waiting for you. This month, we’re focusing on advanced GROUP BY queries. If you’ve finished our SQL Basics, Creating Basic Reports, and GROUP BY Extensions courses or have equivalent knowledge, this is a good way to test your database skills. Are you ready to solve the problems in this month’s SQL practice?
You've just been hired as an SQL specialist by Daisy, who runs a store that sells handmade jewelry. Daisy would like to gather some data that will help her to expand the business. Can you find the number of purchases made by each customer? How much do the customers usually spend on a single purchase?
The answers are hidden in the database - you just need to figure out how to get them out!
Hint: In each exercise, you can see a sample of the data. Look in the right-hand menu, under the
tab.Have fun!
Course progress
Exercises completed
1.
Practice writing SQL queries with our SQL coding practice! Every month, we release a new set of interactive exercises with real-time feedback.