Seagul

Lesson 5 - Total amount spent by each customer

Dataset statusAdvanced SQL exercisesvv1

Exercise content

Using the advanced-exercise dataset (an adaptation of the join_exercise.db block), calculate the total amount spent by each customer at the restaurant.

Use the sales and menu tables.

Hints

Hint 1

Use sales to know who bought something and menu to know how much it costs. After the JOIN, group by customer_id and use SUM(price).

Not completed

Loading dataset...

Latest result

No result set available.