Embedded Files
QUESTIONS
How many orders were placed?
What are the top 5 weeks with the most total orders?
Which pizza sizes bring the most revenue?
Which pizza categories have the most or least sales?
How many pizzas are purchased per order on average?
Which pizza is the most successful?
Which hours have the most pizzas sold?
Which pizza category brings in the most revenue?
Which pizza category brings in the least revenue?
How many pizzas were sold in total?
SELECT
COUNT(DISTINCT order_id) AS Total_Orders
FROM pizza_sales
2. SELECT TOP 5
DATEPART(ISOWW,order_date) AS week_number,
YEAR(order_date) AS years,
COUNT(DISTINCT order_id) AS total_orders
FROM pizza_sales
GROUP BY DATEPART(ISOWW,order_date), YEAR(order_date)
ORDER BY COUNT(DISTINCT order_id) DESC
3. SELECT
pizza_size,
SUM(total_price) * 100 /
(SELECT sum(total_price) FROM pizza_sales) AS PCT
FROM pizza_sales
GROUP BY pizza_size
ORDER BY PCT
4. SELECT
pizza_category,
COUNT(DISTINCT order_id) as pizza_sales
FROM pizza_sales
GROUP BY pizza_category
5. SELECT
CAST(
CAST(SUM(quantity) AS decimal)/
CAST(COUNT(DISTINCT order_id) AS decimal) AS decimal (10,2))
AS Average_Pizzas_Per_Order
FROM pizza_sales
6. SELECT TOP 1
pizza_name,
SUM(total_price) AS total_revenue
FROM pizza_sales
GROUP BY pizza_name
ORDER BY SUM(total_price) DESC
7. SELECT TOP 5
DATEPART(HOUR,order_time) AS order_hour,
SUM(quantity) AS total_pizzas_sold
FROM pizza_sales
GROUP BY DATEPART(HOUR,order_time)
ORDER BY SUM(quantity) DESC
8. SELECT
pizza_category,
SUM(total_price) * 100 /
(SELECT sum(total_price) FROM pizza_sales) AS PCT
FROM pizza_sales
GROUP BY pizza_category
ORDER BY PCT
9. SELECT
SUM(quantity) AS Total_Pizza_Sold
FROM pizza_sales
10. SELECT TOP 1
pizza_name,
SUM(total_price) AS total_revenue
FROM pizza_sales
GROUP BY pizza_name
ORDER BY SUM(total_price)
Page updated
Google Sites
Report abuse