Pizza-Runner-SQL-Case-Study

SQL case study analyzing pizza orders, runner performance, deliveries, customer behavior, and business insights using MySQL.

🍕 Pizza Runner SQL Case Study

📖 Project Overview

This project contains SQL solutions for the Pizza Runner Case Study from the 8 Week SQL Challenge.

The aim of this project is to analyze pizza orders, customer preferences, delivery performance, and runner efficiency using SQL.

---

🎯 Objectives

• Analyze customer orders
• Measure runner performance
• Evaluate delivery success
• Understand customer preferences
• Generate business insights using SQL

---

🛠️ Tools & Technologies

• MySQL
• SQL
• GitHub

---

📂 Database Tables

This case study contains the following tables:

runners

Stores runner registration details.

Column	Description
runner_id	Runner ID
registration_date	Registration Date

---

customer_orders

Stores customer pizza orders.

Column	Description
order_id	Order ID
customer_id	Customer ID
pizza_id	Pizza Ordered
exclusions	Excluded Toppings
extras	Extra Toppings
order_time	Order Time

---

runner_orders

Stores delivery information.

Column	Description
order_id	Order ID
runner_id	Runner ID
pickup_time	Pickup Time
distance	Delivery Distance
duration	Delivery Duration
cancellation	Cancellation Status

---

pizza_names

Contains pizza names.

---

pizza_recipes

Contains recipe information.

---

pizza_toppings

Contains topping details.

---

📌 SQL Concepts Used

• SELECT
• WHERE
• GROUP BY
• ORDER BY
• INNER JOIN
• LEFT JOIN
• Aggregate Functions
• CASE WHEN
• CTE (Common Table Expressions)
• Window Functions
• COUNT()
• SUM()
• AVG()
• RANK()
• ROW_NUMBER()
• String Functions
• Data Cleaning

---

✅ Business Questions Solved

• Total pizzas ordered
• Unique customer orders
• Successful deliveries by runners
• Number of each pizza type delivered
• Customer ordering patterns
• Peak ordering hours
• Delivery distances and durations
• Average delivery time
• Runner performance analysis
• Customer modifications (extras/exclusions)
• Revenue calculations
• Business recommendations

---

📁 Project Structure

Pizza-Runner-SQL-Case-Study/

├── README.md

├── Pizza_Runner_SQL_CaseStudy.sql

└── screenshots/

---

📚 Learning Outcomes

Through this project, I learned:

• SQL Data Cleaning
• Joins
• Aggregate Functions
• Window Functions
• Common Table Expressions (CTEs)
• Business Analytics
• Customer Behavior Analysis
• Delivery Performance Analysis

---

👩‍💻 Author

Sonal Kumari

Aspiring Data Analyst

---

⭐ If you found this project useful, feel free to star this repository.