2022 Monthly SQL Practice Sets - Advanced

Table of contents

1. 1. January 2022 SQL Challenge

   0/15

   Monica needs help running her online shop. Use window functions to help her perform analyses and find answers to her questions.

   List of exercises Start now
   1. Introduction
      1. Introduction
      2. The online shop database and the categories table
      3. The customers table
      4. The orders table
      5. The products table
      6. The orders_items table
   2. Tasks
      1. Task 1
      2. Task 2
      3. Task 3
      4. Task 4
      5. Task 5
      6. Task 6
      7. Task 7
      8. Task 8
      9. Congratulations

2. 2. March 2022 SQL Challenge

   0/16

   Megan is the manager at a local theater. She wants to gather data to expand her business. Can you help her generate reports using SQL?

   List of exercises Buy course
   1. Introduction
      1. Introduction
      2. The theater database and the actor table
      3. The director table
      4. The play table
      5. The event table
      6. The actor_play table
   2. Tasks
      1. Task 1
      2. Task 2
      3. Task 3
      4. Task 4
      5. Task 5
      6. Task 6
      7. Task 7
      8. Task 8
      9. Task 9
      10. Congratulations

3. 3. May 2022 SQL Challenge

   0/11

   Tiffany is a website owner who would like to run her business more efficiently. Use recursive queries to help her gather all the important data.

   List of exercises Buy course
   1. Introduction
      1. Introduction
      2. The website database and the student table
      3. The course table
      4. The student_course table
   2. Tasks
      1. Task 1
      2. Task 2
      3. Task 3
      4. Task 4
      5. Task 5
      6. Task 6
      7. Congratulations

4. 4. July 2022 SQL Challenge

   0/15

   Ruby wants to improve her language tandem app. Use SQL JOINs to search throughout the database and help her gather all the data she needs!

   List of exercises Buy course
   1. Introduction
      1. Introduction
      2. The language tandem app database and the speaker table
      3. The language table
      4. The language_speaker table
      5. The chatroom table
      6. The chatroom_speaker table
   2. Tasks
      1. Task 1
      2. Task 2
      3. Task 3
      4. Task 4
      5. Task 5
      6. Task 6
      7. Task 7
      8. Task 8
      9. Congratulations

5. 5. September 2022 SQL Challenge

   0/14

   Kate owns an electronics store and wants to expand her business. Can you use SQL functions to answer all of her questions?

   List of exercises Buy course
   1. Introduction
      1. Introduction
      2. The electronics store database and the customer table
      3. The device table
      4. The purchase table
      5. The purchase_device table
   2. Tasks
      1. Task 1
      2. Task 2
      3. Task 3
      4. Task 4
      5. Task 5
      6. Task 6
      7. Task 7
      8. Task 8
      9. Congratulations

6. 6. November 2022 SQL Challenge

   0/13

   Daisy owns a store that sells handmade jewelry. She would like to gather some data that will help her grow her business. Can you answer all of Daisy's questions using SQL functions?

   List of exercises Buy course
   1. Introduction
      1. Introduction
      2. The shop's database and the customer table
      3. The purchase table
      4. The product table
   2. Tasks
      1. Task 1
      2. Task 2
      3. Task 3
      4. Task 4
      5. Task 5
      6. Task 6
      7. Task 7
      8. Task 8
      9. Congratulations

Get the Certificate of Competency in SQL

This certificate will confirm your practical SQL problem-solving skills

Obtain the Certificate Learn more