This project explores restaurant menu and order data using SQL. It involves creating relational tables, loading datasets and writing queries to answer key business questions such as popular items, spending patterns, and category-wise performance.
- view the menu items table and write a query to find the number of items on the menu
- What are the least expensive items on the menu?
- What are the most expensive items on the menu?
- How many Italian dishes are on the menu?
- What are the least expensive Italian dishes on the menu?
- What are the most expensive Italian dishes on the menu?
- How many dishes are in each category?
- What is the average dish price within each category?
- View the order details table. What is the date range of the table?
- How many orders were made within this date range?
- How many items were ordered within this date range?
- Which orders had the most number of items?
- How many orders had more than 12 items?
- Combine the menu_items and order_details tables into a single table
- What were the least ordered items? What categories were they in?
- What were the most ordered items? What categories were they in?
- What were the top 5 orders that spent the most money?
- View the details of the highest spend order. Which specific items were purchased?
- View the details of the top 5 highest spend order