What is a common mistake with Select and SelectMany in LINQ?

Using Select when flattening is needed leaves nested sequences and complicates downstream logic. 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.