Mis on agregatsioonifunktsioon?

Aggregating function is a function that takes a set of values and returns a single summarized value that reflects a characteristic of that set.

Examples of aggregating functions:

• Sum (SUM) — sum of all values
• Average (AVG) — arithmetic mean
• Maximum (MAX) — maximum value
• Minimum (MIN) — minimum value
• Count (COUNT) — number of elements

In system analysis, aggregating functions are often used to generalize data, for example, counting the total number of orders, the average time to complete a task, etc.