Competition
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
Continue with GoogleShow more optionsor
Your challenge
Your manager has 4 business questions. For each one, ask the AI assistant for help writing the SQL query, run the query and check the results, and explain in your own words what the SQL does.
- 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.
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
How do I sign up?
How do I compete in DataCamp competitions?
You will create a data analysis based on the dataset provided. You will submit your ready-to-share notebook publication for a review by fellow DataCamp learners and the judging panel in accordance with the evaluation metrics created for the competition.
How long does a competition run?
The detailed information on the competition timeline can be found on the competition’s homepage. Most DataCamp Competitions include two deadlines: a submission deadline (after which no new submissions will be accepted), and a voting deadline (after which no new votes be counted towards final evaluation). It is very, very important to keep these deadlines in mind.
What makes a winning solution?
The winners will be selected based on the judging criteria provided in the description of each competition.
How will I get my prize? Are there any conditions?
We will contact each winner separately to agree on the best way to deliver the prize. The winners are responsible for any fees or taxes liable in your home country upon receiving the funds. Any relevant conditions will be stated in the Competition Rules and Terms of Use.
Are teams allowed?
Not yet, but we are exploring this opportunity for future competitions.