sum two fields in sql code example
Example 1: sql sum and other fields
SELECT sum(a) as car,b,c FROM toys
GROUP BY b, c
Example 2: sql add two values together
SELECT ID, SUM(VALUE1 + VALUE2)
FROM tableName
GROUP BY ID
--or simple addition
SELECT
ID,
(VALUE1 + VALUE2) as AddedValues
FROM tableName