This project analyzes pizza sales data using SQL to generate insights into revenue, order trends, and customer preferences. The database includes tables for orders, pizzas, pizza types, and order details, allowing for comprehensive sales analysis.
Key Features: ✔️ Revenue Analysis – Total & cumulative sales calculations ✔️ Order Trends – Daily, monthly, and category-wise sales breakdown ✔️ SQL Queries – Aggregations, window functions, and joins for insights ✔️ Data Export – Structured .sql file for easy setup
🔹 Technologies Used: MySQL, SQL Window Functions, Aggregate Queries 🔹 Dataset: Simulated pizza sales data
💡 How to Use: Import the .sql file into MySQL and run queries to explore insights.