How many rows does the result contain?
-- orders.region: 'EU', 'US', 'EU', 'APAC', 'US' SELECT region, SUM(total) FROM orders GROUP BY region;
- 2
- 1
- 3
- 5
GROUP BY emits one row per distinct group: EU, US and APAC.-- orders.region: 'EU', 'US', 'EU', 'APAC', 'US' SELECT region, SUM(total) FROM orders GROUP BY region;
GROUP BY emits one row per distinct group: EU, US and APAC.