2021 Monthly SQL Practice Sets - Advanced

Table of contents

1. 1. January 2021 SQL Challenge

   0/15

   Jeremy needs some reports to expand his business. He wants to know which products sold the best, where his customers bought the most, and what categories of products sold the best. Use SQL window functions to answer Jeremy's questions.

   List of exercises Start now
   1. Introduction
      1. Introduction
      2. The category table
      3. The product table
      4. The customer table
      5. The store_order table
      6. The order_item table
      7. Task 1
      8. Task 2
      9. Task 3
      10. Task 4
      11. Task 5
      12. Task 6
      13. Task 7
      14. Task 8
      15. Congratulations

2. 2. March 2021 SQL Challenge

   0/15

   Dona owns a language school. She wants to better serve her students and expand to more locations. Can you help her generate reports by using SQL?

   List of exercises Buy course
   1. Introduction
      1. Introduction
      2. The student table
      3. The teacher table
      4. The course table
      5. The course_edition table
      6. The course_edition_student 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

3. 3. May 2021 SQL Challenge

   0/9

   Luke is a student at a U.S. university. His current class project is to present information about his family tree. Use recursive SQL queries to gather the information he needs.

   List of exercises Buy course
   1. Introduction
      1. Introduction
      2. The person 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 2021 SQL Challenge

   0/17

   John and Tom have decided to start their own sportswear store as a new business. They need your help in deciding what colors are popular, figuring out how to organize their products, and understanding their customers. Can you help them gather the information they need by using SQL JOINs?

   List of exercises Buy course
   1. Introduction
      1. Introduction
      2. The sportswear database and the color table
      3. The customer table
      4. The category table
      5. The clothing table
      6. The clothing_order 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. Task 10
      11. Congratulations

5. 5. September 2021 SQL Challenge

   0/17

   Mia and George run a construction business in Colorado, U.S.A. They would like to understand their customers and their needs for building a home. Use SQL and SQL functions to help them gather the information they need.

   List of exercises Buy course
   1. Introduction
      1. Introduction
      2. The investor table
      3. The plot table
      4. The investor_plot table
      5. The house table
      6. The building 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. Task 10
      11. Congratulations

6. 6. November 2021 SQL Challenge

   0/18

   Sarah is a manager of a running club. She needs your help to decide which running events the members of her club should participate in, what distances are most popular among the members, and how to build the training schedule. Use GROUP BY to help her gather information.

   List of exercises Buy course
   1. Introduction
      1. Introduction
      2. The sportsclub database and the runner table
      3. The event table
      4. The runner_event table
      5. The diet 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. Task 10
      11. Task 11
      12. Task 12
      13. Congratulations

Get the Certificate of Competency in SQL

This certificate will confirm your practical SQL problem-solving skills

Obtain the Certificate Learn more