In SQLite, the total()
function returns the sum of all non-NULL values in a group.
If there are no non-NULL values, then it returns 0.0.
This function is similar to the sum()
function, except in the way it handles NULL inputs. When there are no non-NULL values, then sum()
returns NULL (instead of 0.0 like the total()
function returns).