A SQL project exploring a restaurant's menu and order history to find what's popular, what drives revenue, and what big spenders are actually ordering.
Built around two tables:
- menu_items — dish names, categories, and prices
- order_details — order IDs, dates, and items purchased
- Explored the menu to understand pricing across categories
- Found the most and least expensive dishes overall and within Italian
- Calculated average price per category
- Analyzed order volumes and identified the most and least ordered items
- Tracked down the top 5 highest-spending orders
- Used JOINs to combine order and menu data for deeper analysis
- Broke down high-spending orders by category to spot ordering patterns