EasyOutput prediction
Distinct groups with multi-column GROUP BY
Given this table (sales):
| id | region | product |
|---|---|---|
| 1 | East | Widget |
| 2 | East | Gadget |
| 3 | West | Widget |
| 4 | East | Widget |
How many rows does this query return?
SELECT region, product, COUNT(*) FROM sales GROUP BY region, product;
← → arrow keys to navigate
Sign in to save your progress.