-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathCase Study Questions.txt
More file actions
33 lines (23 loc) · 1.4 KB
/
Copy pathCase Study Questions.txt
File metadata and controls
33 lines (23 loc) · 1.4 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
Case Study Questions – Naz’s Sushi Bar
Total Customer Spend
What is the total amount of money each customer has spent at Naz’s Sushi Bar?
Customer Visit Frequency
How many distinct days has each customer visited the sushi bar?
First Purchase Behavior
What was the first menu item purchased by each customer?
If a customer ordered multiple items on their first visit, return all items.
Top-Selling Menu Item
Which menu item has been purchased the most overall, based on total quantity sold?
Customer Preferences
What is the most popular menu item for each customer, based on total quantity ordered?
Post-Membership Purchase
For each customer who joined the loyalty program, what was the first item they purchased after becoming a member?
Pre-Membership Purchase
What menu item was purchased immediately before each customer became a member?
Spending Before Membership
For each customer, what is the total number of items purchased and the total amount spent before they joined the loyalty program?
Loyalty Points Calculation
If every £1 spent earns 10 loyalty points, and sushi earns double points, how many total loyalty points has each customer earned?
Promotional Bonus Period
During the first 7 days starting from a customer’s membership join date (inclusive), all menu items earn double points.
How many loyalty points do Customer A and Customer B have by the end of January 2025?