Back to articles list Articles Cookbook
3 minutes read

New Monthly SQL Practice for July 2024!

Ready for our new SQL challenge? This time, the tasks are slightly more difficult. In this course, you will assist Chinook’s management in analyzing company performance using SQL JOINs. Welcome to the July SQL Practice course!

In our July 2024 SQL Practice, you will work with the Chinook database. Chinook is a digital music store. Its management has hired you, an SQL specialist, to gain important insights into the business. You will identify popular tracks, calculate revenue, prepare marketing campaigns, and do much more. Try to solve all the tasks in the course. The answers are hidden in the database; you just need to figure out how to get them out using SQL.

This SQL Practice is at an advanced level. It is aimed at those who have finished our SQL Basics and SQL JOINs courses or those who otherwise have the equivalent knowledge. You need to understand all types of SQL JOINs to solve the exercises in this course. If you are not comfortable using JOINs, check out the courses mentioned above first and then come back here for more practice.

Our interactive SQL course is a great way to test your skills and put what you have learned so far into practice. The exercises are fun, so you do not get bored while learning. And thanks to the interactive online console, you write real SQL queries and see their results.

You do not need to install or set anything up. A web browser and your willingness to practice SQL are enough.

Maybe this is the first time you’ve come across our Monthly SQL Practices. offers one SQL Practice each month: basic levels on even-numbered months and advanced levels on odd-numbered months. Each SQL Practice takes about an hour (or less!) and contains 5–10 exercises to help you hone your skills.

Each Monthly SQL Practice features a different business or hobby. We’ve had practices featuring 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.

Our exercises are based on real business scenarios. There are no abstract theories here, just everyday business problems. You can copy most of the SQL queries you write in these exercises and use them in your own projects. This is what they call a hands-on SQL course!

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

Practice your SQL skills and help Chinook management gain a better understanding of its business. Start the July 2024 SQL Practice course now!

Have fun!