3 ms·
It is useful to have the sum and product of empty lists be 0 and 1, respectively. This means that sum(A ++ B) = sum(A) + sum(B). (++ is concatenation)
by petters 6y ago
It is useful to have the sum and product of empty lists be 0 and 1, respectively.
This means that sum(A ++ B) = sum(A) + sum(B). (++ is concatenation)
- magicalhippo 6y agoAnd you can have that by using COALESCE(SUM(A), 0) for example.