Hi , This is an SQL project which i have developed to solve SQL use case given by Danny's following His 8 week SQl challenge series.
Links here is the link of SQL challange Case Study #1 - Danny's Diner
https://8weeksqlchallenge.com/case-study-1/
Introduction
In this Task I try to solve and answer all query related to this task and find insights from data for answer a few simple questions about his customers, especially about their visiting patterns, how much money they’ve spent and also which menu items are their favourite. Having this deeper connection with his customers will help him deliver a better and more personalised experience for his loyal customers.
Description
Danny plans on using these insights to help him decide whether he should expand the existing customer loyalty program - additionally he needs help to generate some basic datasets so his team can easily inspect the data without needing to use SQL.
Danny has provided you with a sample of his overall customer data due to privacy issues - but he hopes that these examples are enough for you to write fully functioning SQL queries to help him answer his questions!
Danny has shared with you 3 key datasets for this case study:
Table 1: sales
Table 2: menu
Table 3: members
Summarry
A and B purchased Sushi and Curry just before the customer became a member. A and B purchased Sushi and Curry first after they became a member. Ramen, Sushi, Curry was the most popular for each customer. Ramen most purchased item on the menu. A: 4, B :6, C : 2 days visited the restaurant A: 76, B : 74, C : 36 Rs spent at the restaurant.
Attachments
https://github.com/prafullgangrade/Danny-s-Dinner_SQL_Challenge-1.git