The sum()
aggregate computes the sum or total of
all the non-NULL
values. Any non-NULL number
that is not an integer will be interpreted as a
floating-point value.number
If all non-NULL
values are integers, number
sum()
will return an integer. Otherwise,
sum()
will return a
floating-point value. If no non-NULL
is found, number
sum()
will return NULL.