This repository contains SQL queries to perform data analysis on pizza sales data. The analysis covers various aspects such as order quantities, revenue, pizza preferences, and temporal patterns.
-
Total Number of Orders Placed
-
Total Revenue Generated from Pizza Sales
-
Highest-Priced Pizza
-
Count of Pizza Size Ordered
-
Top 5 Most Ordered Pizza Types along with Their Quantities
-
Total Quantity of Each Pizza Category Ordered
-
Distribution of Orders by Hour of the Day
-
Category-wise Distribution of Pizzas
-
Average Number of Pizzas Ordered per Day
-
Top 3 Most Ordered Pizza Types Based on Revenue
-
Percentage Contribution of Each Pizza Type to Total Revenue
-
Cumulative Revenue Generated Over Time
-
Top 3 Most Ordered Pizza Types Based on Revenue for Each Pizza Category