[go: up one dir, main page]
Scribd
Upload
44 views13 pages

Pizza Sales Analysis Solution

Uploaded by

testae816
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
44 views13 pages

Pizza Sales Analysis Solution

Uploaded by

testae816
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 13

KISHAN KUMAR

NIT JAMSHEDPUR

PIZZA SALES ANALYSIS


MY SQL
Data File -
DATA FILES
https://github.com/Kish 01 PIZZAS.CSV-
This file includes details about individual pizzas, with columns for pizza_id,
ankumar2100/Pizza-
pizza_type_id, size, and price. It provides the basic structure needed to
Sales-Analysis understand the different types of pizzas, their sizes, and their pricing.

02 PIZZA_TYPES.CSV
This file categorizes the pizzas further by providing pizza_type_id,
name, category, and ingredients. It helps in identifying the type and
category of each pizza, along with a detailed list of ingredients.

03 ORDERS.CSV
This file captures the order details, including order_id, date, and time. It is essential
for analyzing when orders were placed and understanding sales trends over time.

04 ORDER_DETAILS.CSV
This file connects orders with specific pizzas, containing order_details_id, order_id,
pizza_id, and quantity. It provides a detailed view of what was ordered in each transaction
and is crucial for analyzing order patterns and customer preferences.
Q1. Retrieve the total number of orders
placed.

SQL QUERY

OUTPUT
Q2.Calculate the total revenue generated
from pizza sales.

SQL QUERY

OUTPUT
Q3.Identify the highest-priced pizza.

SQL QUERY

OUTPUT
Identify the most common pizza size
ordered.
SQL QUERY

OUTPUT
List the top 5 most ordered pizza types
along with their quantities.
SQL QUERY

OUTPUT
Join the necessary tables to find the total
quantity of each pizza category ordered.
SQL QUERY

OUTPUT
Determine the distribution of orders by
hour of the day.
SQL QUERY

OUTPUT
Join relevant tables to find the category-
wise distribution of pizzas.
SQL QUERY

OUTPUT
Group the orders by date and calculate the
average number of pizzas ordered per day.
SQL QUERY

OUTPUT
Determine the top 3 most ordered pizza
types based on revenue.
SQL QUERY

OUTPUT
THANK YOU
Github Link -
https://github.com/Kishankumar2100/Pizza-
Sales-Analysis

You might also like