GitHub - Dhavaltharkar/zomato_case_study: Done Analysis on Zomato case study using SQL

Name		Name	Last commit message	Last commit date
Latest commit History 9 Commits
Markdown		Markdown
.gitattributes		.gitattributes
README.md		README.md
foods.sql		foods.sql
menu.sql		menu.sql
order_details.sql		order_details.sql
orders.sql		orders.sql
output.pdf		output.pdf
restaurants.sql		restaurants.sql
users.sql		users.sql
zomato_case_study.sql		zomato_case_study.sql

Repository files navigation

Q1. Find the customers who have never oredered?

Q2. Whatt is the average price of per dishes?

Q3. Find top restaurants in terms of number of orders for a given month?

Q4. Restaurants with monthly sales greater than 800 for restaurant?

Q5. Show all orders with order details for a particular customer in a particular date range?

Q6. Find restaurants with maximum number of repeated customers?

Q7. Month over month revenue growth of Zomato?

Q8. Find favourite food of customer?

About

Done Analysis on Zomato case study using SQL

mysql sql workbench

Report repository

Releases

No releases published

Packages

No packages published

Languages

SQL 100.0%