What is a common mistake with deferred execution in LINQ?

Enumerating the same deferred query multiple times can repeat expensive work or produce changing results. 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.