Grouping
2 / 12
EasyOutput prediction

COUNT per group

Given this table (orders):

idcustomerstatus
1Aliceshipped
2Bobpending
3Alicepending
4Aliceshipped

What does this query return?

SELECT customer, COUNT(*) FROM orders GROUP BY customer;

← → arrow keys to navigate

Sign in to save your progress.