Aggregation¶
Functions for computing statistics over collections.
LENGTH(x)/COUNT(x)→ size of strings, lists, or objects;0fornull.SUM(list)→ sum of numbers; errors on non-numeric entries;0when list is empty.AVG(list)→ average ornullwhen empty; errors on non-numeric entries.MIN(list)/MAX(list)→ smallest/largest value ornullwhen empty; errors on incomparable values.
Run it: Aggregation example.