Skip to main content
CompetitionsLearn SQL with AI: Mini Business Cases

Competition

Finished
Learn SQL with AI: Mini Business Cases

Learn SQL with AI: Mini Business Cases

Welcome to PageTurner Books, a small online bookstore! You've just joined as a data analyst, and your manager needs quick answers from the sales database. The good news? You have an AI assistant to help you write SQL queries. The key is not just getting the answer—it's understanding what each query does. In this challenge, you'll tackle real business questions using SQL. For each question, use the AI assistant to help write your query, run it to get results, and explain in plain English what it does and why. This is how data analysts work in the real world—AI helps with the syntax, but you need to understand the logic!

Prize

KNOWLEDGE

Challenge yourself and try this competition for free

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.

Your challenge

  • Challenge 1: Genre Inventory - How many books do we have in each genre?
  • Challenge 2: January Sales - What was our total revenue in January 2024?
  • Challenge 3: Top Customers - Who are our top 5 customers by total spending?
  • Challenge 4: Your Discovery (Bonus!) - What other interesting insights can you find in our data?

How to get started

Use the AI assistant to write SQL queries that answer business questions, then explain what each query does in your own words.

1
Run the preview cells to load the data tables (books, customers, orders)
2
For each challenge, use the AI assistant to help write your SQL query
3
Run your query and check the results
4
Write your explanation in the markdown cell below each query
5
Publish your workbook before the deadline

Judging criteria

What Makes a Great Submission?

  • Working queries that answer the business questions
  • Clear explanations that show you understand what the SQL does
  • Curiosity in the bonus challenge—explore and have fun!

Rules

  • Complete the challenges using the provided database
  • Write explanations for each query in your own words
  • Publish your workbook before the deadline

Note: Please ensure you are 18+ and permitted to enter a skill-based competition in your country. Entrants may not be located in a country currently sanctioned by the U.S. government.

FAQs

Challenge yourself and try this competition for free

Register