An aggregate function includes values grouped together to form a single value that provides a summary of the data list.

SQL window functions provide extremely powerful and useful features that let you work with observations more easily. Different types explained here.