What is a common mistake with GroupBy and aggregation in LINQ?

Materializing before grouping can move a large aggregation into application memory. In practice, the value of this concept comes from understanding where it belongs in the architecture, what problem it solves, and what constraints or tradeoffs it introduces.