lilrachel1985 / business_customer_analytics Goto Github PK

This project analyzes order data to identify the most and least popular menu items and types of cuisine using SQL. Objective 1 -We view the menu_items table and write a query to find the number of items on the menu

-What are the least and most expensive items on the menu?

-How many Italian dishes are on the menu? What are the least and most expensive Italian dishes on the menu?

-How many dishes are in each category? What is the average dish price within each category?

Objective 2 -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?

Objective 3 we Analyze customer behavior -Combine the menu_items and order_details tables into a single table

-What were the least and 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 orders