I think this is an example of why people don't like to use OVER, since it's so hard to work out what might/will be returned!

I'd like to see a simpler question or articles on how OVER works - any takers?