SQL Aggregation Functions

What kinds of aggregation can you do in SQL? Notes:

TODO: Do some of these have special semantics w.r.t. NULLs?
 * Generally, these aggregate functions ignore NULLs.
 * Not all DBMSes support all aggregation functions.