GROUP BY and HAVING: How to Summarize Rows Without Getting a Fake Answer

What GROUP BY actually does to your rows, why WHERE and HAVING are not interchangeable, and the one line that stops a category of eleven records from topping your chart. Worked on 82,956 real games.