Back to articles list Articles Cookbook
2 minutes read

New Monthly SQL Practice for July 2023!

Ready for our new SQL challenge? This time, we have prepared slightly more difficult SQL tasks. Here’s the July SQL Practice course!

You will help Isabella, the founder of an online home swap platform. On this platform, homeowners can find a place to stay for vacation by swapping homes with other homeowners. Isabella would like to gather data to help her expand the business, and she has hired you as an SQL specialist. Which locations are the most desired by the platform users? How many homeowners have listings in more than one country? The answers are hidden in the database – you just need to find them using SQL JOINs!

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

Each month, offers a set of interactive 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 from this practice set, adapt them for 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 the platform owner grow her business! Start the July SQL Practice course now!

Have fun!