specifying multiple distinct columns in a COUNT() function.

[marist89]

Originally posted by jmodic
YES. Much more elegant solution. Although there is one more sort operation here, there is no implicit datatype conversion which might result in better performance.

I vote for COOL over FAST & EFFICIENT every time.