SELECT ID, SUM(VALUE1 + VALUE2)
FROM tableName
GROUP BY ID
--or simple addition
SELECT
ID,
(VALUE1 + VALUE2) as AddedValues
FROM tableName
INSERT INTO table_name (column_list)
VALUES
(value_list_1),
(value_list_2),
...
(value_list_n);
Max number of rows is 1000. Inserting rows returned from a SELECT
is done with
INSERT INTO table_name (column_list)
SELECT ... FROM ... (...rest of select statement...);