Grouping
1 / 12
EasyOutput prediction

Basic GROUP BY

Given this table (orders):

idcustomeramount
1Alice100
2Bob200
3Alice300

What does this query return?

SELECT customer, SUM(amount) FROM orders GROUP BY customer;

← → arrow keys to navigate

Sign in to save your progress.