01_basic_analysis.sql

 -- Q1) Retrieve the total number of orders placed.
  
  select count(order_id) as Total_orders from orders;

-- Q2)   Calculate the total revenue generated from pizza sales.
SELECT 
    ROUND(SUM(order_details.quantity * pizzas.price),
            2) AS total_sales
FROM
    order_details
        JOIN
    pizzas ON pizzas.pizza_id = order_details.pizza_id

-- Q3)Identify the highest-priced pizza.

SELECT 
    pizza_types.name, pizzas.price
FROM
    pizza_types
        JOIN
    pizzas ON pizza_types.pizza_type_id = pizzas.pizza_type_id
ORDER BY pizzas.price DESC
LIMIT 1;

-- Q4) Identify the most common pizza size ordered.

	select pizzas.size, count(order_details.order_details_id) as order_count
    from pizzas join order_details
    on pizzas.pizza_id=order_details.pizza_id
    group by pizzas.size order by order_count desc;

	-- Q5)List the top 5 most ordered pizza types along with their quantities.
    
select pizza_types.name,sum(order_details.quantity) as quantity
from pizza_types join pizzas
on pizza_types.pizza_type_id=pizzas.pizza_type_id
join order_details
on order_details.pizza_id=pizzas.pizza_id
group by pizza_types.name order by  quantity limit 5;