COUNT() is a function that returns the number of items found in a group. Syntax-wise, it is very easy, but it can be tricky to get the best performance out of it.