• ...This can produce some surprising results. This is because of the way that COUNT() works...

    Why the surprise if COUNT exactly does what is described in e.g. Technet?