Small. Fast. Reliable.
Choose any three.

aggregate-function-invocation

aggregate-func ( DISTINCT expr ) filter-clause , * ORDER BY ordering-term ,


References:   expr   filter-clause   ordering-term
See also:   lang_aggfunc.html   lang_expr.html