What are some SQL aggregates and other built-in functions?

The common aggregate, built-in functions are AVG, SUM, MIN, MAX, COUNT and DISTINCT.