New Monthly SQL Practice for September 2022!

This time, you will help Kate who runs an electronics store. Kate would like to gather some data to help her expand her business. She has hired you as an SQL specialist to help her out. Can you find out the average number of purchases made by each customer? Can you calculate the prices for customers with loyalty cards? The answers are in the database. You just need to figure out how to get them out using SQL functions.

This SQL Practice is at an advanced level, that is, for those who have finished our SQL Basics and Standard SQL Functions courses or those who have equivalent knowledge. If you don’t feel comfortable working with SQL functions yet, check out these courses and then come back here for more practice.

Every month, LearnSQL.com offers a set of interactive SQL exercises for you to practice writing real SQL queries in real-life scenarios. Each 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 from this practice set, 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 practice 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 the store owner grow her business! Start September’s SQL Practice course now.

Have fun!