Back to articles list January 1, 2021 - 2 minutes read New Monthly Challenge for January 2021! LearnSQL.com Team Tags: sql challenge This month’s LearnSQL.com Monthly Challenge is now available! In January, you can test your SQL skills in window functions by solving problems for Jeremy, the manager of the clothing retailer, Edward. Is this the first time you’ve come across our Monthly Challenge? LearnSQL.com delivers one SQL Challenge each month to our users. Starting in January 2021, we have monthly challenges separately for beginners and for advanced users. Each challenge contains 5 to 10 SQL exercises, prepared for those who want to practice their skills. It shouldn’t take you more than an hour to solve these tasks. Each Challenge features a different type of business, problem, or hobby. So far, we’ve had challenges on job searches, stars and astronomy, an auto repair shop, a bakery, pizza, popular movies, books, and more. The theme for January is preparing reports for a clothing retailer. In our January 2021 SQL Challenge, you’ll meet Jeremy and his colleague, Jack. Jeremy needs reports to develop his business. Jack knows SQL and window functions; he will try to support Jeremy. However, Jack is not as good as you are and needs your help. Jeremy wants to know which products sold the best, where his customers bought the most, what categories of products sold the best, etc. Can you help Jeremy and Jack find the answers to these questions? If you have finished our Window Functions course, it shouldn’t be too hard, so, don’t worry. Remember to use the hints and have fun! Tags: sql challenge You may also like New Monthly Challenge for December 2020! The new LearnSQL.com Monthly Challenge is ready! Read more New Monthly SQL Challenge for November 2020! The new LearnSQL.com Monthly Challenge is ready! Read more New Monthly SQL Challenge for October 2020! The new LearnSQL.com Monthly Challenge is ready! Read more New Monthly Challenge for September 2020! The new LearnSQL.com Monthly Challenge is ready! Read more New Monthly Challenge for August 2020! New Monthly Challenge for August 2020! Read more New SQL Monthly Challenge for July 2020! The new LearnSQL.com Monthly Challenge is ready! In July, we invite you to sharpen your SQL skills with some questions about US states. Read more New SQL Monthly Challenge for June 2020! The new LearnSQL.com Monthly Challenge is ready! In June, we invite you to use your SQL skills to analyze insurance agency activities. Read more New SQL Monthly Challenge for May 2020! The new LearnSQL.com Monthly Challenge is ready! In May, we invite you to use your SQL knowledge to help a bakery manager buy a new oven. Read more New SQL Monthly Challenge for April 2020! The new Monthly Challenge on LearnSQL.com is ready! In April, we invite you to test your SQL knowledge with data from another area of business: automobile repair. Read more Subscribe to our newsletter Join our weekly newsletter to be notified about the latest posts.