prod number|null avg(array[number] value) Returns the product of the items in an array of numbers, or null if the array is empty. It is a type error if the provided value is not an array the array contains items that are not numbers Examples