xxxxxxxxxx
SELECT ID, SUM(VALUE1 + VALUE2)
FROM tableName
GROUP BY ID
--or simple addition
SELECT
ID,
(VALUE1 + VALUE2) as AddedValues
FROM tableName
xxxxxxxxxx
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 );