Our website uses cookies. By using this website, you agree to their use in accordance with the browser settings. You can modify your browser settings on your own. For more information see our Privacy Policy.


Interactive Course

Monthly SQL Practice – January 2021

Curious what juicy queries we've got for you this time? Be sure to check this month's challenge!

Table of contents

Ultimate money saver


With our Forever plan this course will cost you only

$ 4.37

85% OFF

38 hours left


Interactive exercises

1 h

Estimated time


Users enrolled


1 ratings

January 2021 SQL Challenge

Our next monthly SQL Challenge is waiting for you! Starting in January 2021, you get to test your SQL skills on new tasks and on a new topic at an advanced level.

If you have fundamental knowledge of SQL and of window functions – if you've finished our Window Functions course – this is a good way to practice your skills. Are you ready for this challenge?

Let's get started!

Help Jeremy and Jack Develop the Clothing Retailer!

January is the first month in a new year. Jeremy, like other managers, is planning business development for the year and needs reports about his business from the marketing department. Jack works there and knows SQL. However, he needs your help in preparing these special reports using window functions in SQL. In this challenge, you’ll help Jeremy and Jack using the database clothing_store. Jeremy wants to understand orders, customers, and sales. Can you help them?

If you have finished our Window Functions course, you know enough to help Jack to prepare the reports about products sold and other order details. Give it a try! (Hint: In each exercise, you can see a sample of the data. Look in the right-hand menu, under the "Database" tab.)

Table of contents


Paid content


Course progress


Exercises completed

1. Challenge

Practice SQL with our coding challenges! Each month, there’s a new set of exercises to solve with real-time feedback.


Exercises completed

Reviews (0)

Average rating

5.00 / 5


1 ratings


5 stars


4 stars


3 stars


2 stars


1 stars