• You should only rely on clauses evaluating in order when no aggregates are involved.

    Good job the question didn't include any of those or I'd have been scuppered!