Tables you can query

`pizzas`

id, name, category, price, calories, is_vegetarian, chef_id

`customers`

id, name, city, favorite_topping, loyalty_points, joined_on

`orders`

id, customer_id, pizza_id, quantity, ordered_at, delivered

`chefs`

id, name, specialty, years_experience, hourly_wage

Example queries

SELECT name, category, price FROM pizzas ORDER BY price DESC;

SELECT p.name, SUM(o.quantity * p.price) AS revenue
FROM orders o JOIN pizzas p ON o.pizza_id = p.id
GROUP BY p.name ORDER BY revenue DESC;