aggregate function
a function summarizing multiple values into one summary statistic
window function
kind of function in SQL; calculations across a set of table rows that are somehow related to the current row
a function summarizing multiple values into one summary statistic