cookies-icon

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.

Course

Advanced

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

Lifetime access

B042DDD8-A1C9-4053-8AF3-463EB31543B8@2x

limited to this course only

$29

Buy now

Want a better deal?

B042DDD8-A1C9-4053-8AF3-463EB31543B8@2x

Get unlimited lifetime access to all 53 present and future courses

Save $420

Unlimited lifetime access

B042DDD8-A1C9-4053-8AF3-463EB31543B8@2x

to all 53 present and future courses

$ 179

$ 599

70% OFF

Buy now Full pricing
15

Interactive exercises

1 h

Estimated time

66

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

Free

Paid content

0%

Course progress

0/15

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.

0/15
Start now

Reviews (0)

Average rating

5.00 / 5

☆☆☆☆☆
★★★★★

1 ratings

Details

5 stars

100%

4 stars

0%

3 stars

0%

2 stars

0%

1 stars

0%