Seagull

Lesson 5 - 6. First menu item purchased by each customer

Dataset statusAdvanced SQL exercisesvv1

Exercise content

Using sales and menu, find the first menu item purchased by each customer.

If multiple items were purchased on the same first day, return all of them without duplicates.

Hints

Hint 1
For each customer_id, you need to find the earliest purchase date. Think of MIN(order_date) grouped by customer.
Hint 2
After finding the first date, join that result back to the rows in sales. This way you can retrieve all purchases made on that exact day.
Hint 3
To get product_name, do a JOIN with menu on product_id. If there are multiple products on the same day, do not remove them by mistake.

Not completed

Loading dataset...

Latest result

No result set available.