LinkedIn
About

Welcome to the SQL Holiday Quizzes! 🎅✨

Join four grade-school friends (Adrien, Iban, Solene, and Benedict) on their holiday adventures and solve fun SQL challenges!

Adrien, Iban, Solene, and Benedict have set up a holiday treats stand 🎄 to earn pocket money for the holidays. 🎅✨
Each day, after school, they sell gingerbread cookies 🍪, hot chocolate ☕, candy canes 🎋, and brownies 🍫.

The four friends want to analyze their sales performance. For each scenario, answer the question using SQL. You can try multiple times until you get it right.

Have fun and happy querying! 🎅✨
New quizzes will be added regularly

SQL Quiz 1: Get Started - Count all the sales performed 🎅✨
SQL Quiz 2: How many brownies has Benedict sold so far? 🍪🎄
SQL Quiz 3: How many treats were sold on December 1st? 🎉🎄
SQL Quiz 4: Total Revenue - How much money did our friends make? 🍪🎄
SQL Quiz 5: Top Earner - Which friend made the most money? 🎅✨
SQL Quiz 6: Top Seller - Which friend sold the most treats? 🍪✨
SQL Quiz 7: Friend's Contribution - What is each friend's share of the total revenue? 🎁🎄
SQL Quiz 8: Breaking the 40-Treat Barrier 🍪🎄
SQL Quiz 9: Top 3 Dates - When were the biggest sales? 🎉🎄
SQL Quiz 10: Top 3 Dates - When were the biggest sales, and which day was that? 🎉🎄
SQL Quiz 11: Top 2 Days - Which days of the week were the most successful? 🎅✨
SQL Quiz 12: Top Week - Which week had the highest sales? 🎅✨
SQL Quiz 13: Looking for a Myster-IOUS Customer ✨🎄
SQL Quiz 14: How Old Are You, Really? 🎉🎄
SQL Quiz 15: Who’s a Kid, Who’s a Senior? 🎅✨