New Monthly SQL Practice for January 2022!

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

This time you will be helping Monica, the owner of an online store. She’d like to analyze her business data and earn more. It’s the perfect opportunity to use your SQL window functions skills. Can you find out how many customers she has in each country? Can you create reports to help her see sales trends? You will find all the answers in the data. You just need to figure out how to get them out of the database using SQL window functions.

Never heard of window functions before? You can learn them in our Window Functions course or find out when to use them in our blog. Once you're comfortable working with window functions in your queries, 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 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 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 store owner grow her business! Start January’s SQL Practice course now!

Have fun!