Why are aggregate functions called so? Name some aggregate functions.
A multiple row function works on multiple values. These functions are called aggregate functions or group functions.
Ex : MAX, MIN, AVG