Add support for missing aggregate functions and support various data types as inputs to the aggr functions.

Add support for more aggregate functions. Expand the scope of existing aggregate functions to more datatypes including nullable types.