I know I need to have (although I don't know why) a
GROUP BY clause on the end of a SQL query that uses any aggregate functions like
SELECT count(userID), userName FROM users GROUP BY userName
When else would
GROUP BY be useful, and what are the performance ramifications?