New Monthly SQL Practice for November 2022!

You’re an SQL specialist helping Daisy, who is running a jewelry store. Daisy would like to gather some data that will help her 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!

This SQL Practice is at an advanced level and focuses on advanced GROUP BY queries. The practice is aimed at those who have finished our SQL Basics, Creating Basic Reports, and GROUP BY Extensions courses or who have the equivalent knowledge. If you don’t feel comfortable working with advanced GROUP BY queries yet, make sure to check these courses out and then come back here for more practice.

Each month, LearnSQL.com offers a set of interactive SQL exercises for you to practice writing real SQL queries in real-life scenarios. Every Monthly SQL Practice features a different business or hobby. We’ve had practices that feature family trees, a language school, a book exchange, a job agency, rental cars, stars and astronomy, auto repair, baking, pizza, movies, U.S. cities, and more. And these aren’t just theoretical exercises; you can copy your SQL queries, adapt them to your database, and use them in your own projects.

Our SQL practice features basic exercises on even-numbered months and advanced tasks on odd-numbered months. Each SQL practice course includes up to 10 interactive SQL exercises to help you improve your skills. The whole thing takes an hour or less to complete.

As a reminder, this month’s SQL Practice is at an advanced level. Remember to use the hints!

Practice your SQL skills and help Daisy grow her business! Start the November SQL Practice course now!

Have fun!