CREATE TABLE NEW_TABLE AS
SELECT field1, field2, field3, SUM(somenumber)
FROM BIG_TABLE
GROUP BY field1, field2, field3;