Back to articles list Articles Cookbook
2 minutes read

New Monthly SQL Practice for July 2021!

If you are a more advanced SQL user who is comfortable writing complex JOINs, you can check your knowledge with July’s SQL Practice. Every month on, you‘ll find a new challenge to solve.

Maybe this is the first time you’ve come across our Monthly SQL Practices. offers one free 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 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.

In our July 2021 SQL Practice, you’ll meet John and Tom – new businessmen who decided to run their own sportswear store. They need you to help them decide what colors are popular, figure out how to organize their products, and understand their customers. Can you help them gather needed information by using your SQL powers? It shouldn’t be too hard if you have finished our SQL Basics course and SQL JOINs course or understand the concepts we’ve covered there.

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