🍕 Pizza Data Analysis (SQL)

📌 Project Overview

This project analyzes pizza sales data using SQL to find business insights like revenue, top-selling pizzas, and order patterns.

📊 Datasets Used

• orders.csv
• order_details.csv
• pizzas.csv
• pizza_types.csv

🛠️ Tools Used

• MySQL Workbench
• SQL
• GitHub

📈 Analysis Performed

• Total revenue calculation
• Top-selling pizzas
• Revenue by pizza size
• Peak order hours
• Category-wise sales analysis

📁 Folder Structure

• data/ → CSV datasets
• sql/ → Table creation & data loading scripts
• analysis_queries/ → Business SQL queries
• screenshots/ → Output images

🚀 How to Run

1. Create database in MySQL
2. Run SQL/create_tables.sql
3. Run SQL/insert_data.sql
4. Execute analysis_queries files

🚀 Conclusion

This project helped me practice SQL concepts like JOIN, GROUP BY, HAVING, and window functions.

👩‍💻 Author

Tapati Paul