Seagull

Lesson 5 - 8. Items and spending before membership

Dataset statusAdvanced SQL exercisesvv1

Exercise content

Using sales, menu, and members, find for each member:

the number of items purchased before becoming a member
the total amount spent before membership

Hints

Hint 1
You only need purchases where order_date is earlier than join_date. So you also need to use the members table.
Hint 2
After filtering, group by customer_id. Use COUNT(*) for the items and SUM(price) for the amount spent.

Not completed

Loading dataset...

Latest result

No result set available.