What does GROUP BY clause do, exactly?
For the life of me, I can't understand it from the explanation given in the book (Chapter 7, pg. 115):
"When the aggregate functions are used with a GROUP BY clause, a single aggregate value will be returned for each row in the result set."
That may be not Geek anymore, but it's not quite yet English. How can this be explained using simple Socratic examples?
Do I understand it correctly that the GROUP BY clause breaks down into smaller chunks what would otherwise be one larger result?
Or let me approach it from a different angle: in what way GROUP BY is different from ORDER BY?
Thanks in advance for the explanation, as always!