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 2022

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 57 present and future courses

Save $420

Unlimited lifetime access

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

to all 57 present and future courses

$ 179

$ 599

70% OFF

Buy now Full pricing
15

Interactive exercises

2 h

Estimated time

106

Users enrolled

☆☆☆☆☆
★★★★★

1 ratings

Welcome to this month's SQL Practice! This time we have prepared something a bit more difficult. If you've finished our Window Functions course or know how to use window functions in SQL, this is a good way to test your skills.

Can You Help Monica Analyze Her Business Data?

Monica runs her own online store. She asked you, an SQL specialist, for help with some data analysis. Use your database skills and help Monica answer business questions. Can you find out which product in her store is the second most expensive? Are you able to rank her products based on their price?

Laptop with credit card and tiny shipping packages

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.

The queries you will be writing are not theoretical; you could reuse them in your own projects. Copy them and adapt them to your databases as needed!

This is an advanced set of exercises. If you're not familiar with SQL window functions, check out our Window Functions course first.

In each exercise, you can see a sample of the data. Look in the right-hand menu, under the "Database" tab.

Practice your SQL skills and help the store owner grow her business!

Have fun!

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%