Danny Ma's SQL 8 Weeks Challenge - Case Study 2: Pizza Runner | SQL Analytics Tutorial

Welcome to Case Study 2: Pizza Runner from Danny Ma's SQL 8 Weeks Challenge! 🍕 In this video, we will dive deep into SQL analytics and solve real-world business problems for a fictional pizza delivery company, Pizza Runner. This case study focuses on optimizing delivery operations, analyzing customer orders, and tracking runner performance.
🔍 What You'll Learn:
How to query relational databases with complex SQL queries
Analyzing order trends and runner efficiency
Calculating key metrics for a pizza delivery business
Hands-on practice with Snowflake and SQL for data analysis
We'll cover the following key questions:
How many pizzas were ordered?
How many unique customer orders were made?
How many successful orders were delivered by each runner?
How many of each type of pizza was delivered?
Maximum pizzas delivered in a single order, and much more!
Whether you're a beginner or looking to sharpen your SQL skills, this video will guide you through practical SQL use cases step-by-step.
📘 Download the case study: 8weeksqlchalle... 🔗 Get the SQL scripts and datasets: github.com/Bam...
Don't forget to like, share, and subscribe for more SQL challenges and tutorials! 🔔
#SQLChallenge #PizzaRunner #DannyMa #DataAnalytics #SQLTutorial #DataScience