🍕 MySQL Pizza Sales Analysis

This project is a comprehensive analysis of a pizza sales database using MySQL. It consists of 15 business-oriented questions ranging from basic to advanced SQL queries. The goal is to extract meaningful insights using real-world SQL techniques such as joins, aggregations, window functions, and subqueries.

---

🧠 Questions Covered

✅ Basic

1. Total number of orders placed
2. Total revenue from pizza sales
3. Highest-priced pizza
4. Most common pizza size
5. Top 5 most ordered pizza types

✅ Intermediate

6. Quantity of each pizza category ordered
7. Order distribution by hour
8. Category-wise pizza distribution
9. Average number of pizzas ordered per day
10. Top 3 pizza types by revenue

✅ Advanced

11. % revenue contribution of each pizza type
12. Cumulative revenue over time
13. Top 3 pizzas by revenue for each category

---

📂 Folder Structure

mysql-pizza-sales-analysis/
├── README.md               # This file
├── Questions.txt           # All 15 questions
├── solutions.sql           # SQL queries for each question
├── assets/                 # (Optional) ERD, screenshots
│   └── schema.png
├── docs/                   # (Optional) Summary report
│   └── Pizza_SQL_Report.pdf


📦 Tools Used

* MySQL 8.0+

* MySQL Workbench / DBeaver

* SQL Window Functions

* Joins, Aggregates, Subqueries

📊 Key Features

* Daily, hourly, and category-wise sales analysis

* Cumulative revenue using SUM() OVER()

* Top pizzas by quantity and revenue

* Percentage-based contribution calculations

🛠️ How to Use

* Load your database using the provided schema.

* Open solutions.sql in MySQL Workbench.

* Run each query to see insights based on real data.

* Modify or extend the queries to explore further.

👨‍💻 Author

Prabhav Gupta
📧 2010prabhavgupta@gmail.com
🔗 www.linkedin.com/in/prabhav91