If you want to to it at script level, don´t use AGGR
DATE, LANGUAGE, [CALL TYPE], LEVEL 1, LEVEL 2, LEVEL 3, STRATEGY,
SUM(SECONDS) AS TOTAL_SECONDS
SUM(CALLS) AS TOTAL_CALLS
DATE, LANGUAGE, [CALL TYPE], LEVEL 1, LEVEL 2, LEVEL 3, STRATEGY;
DROP TABLE tmp:
I guess my issue is more as to where does the SUM need to be, and where does the GROUP BY need to be, same as the coma (",") and semi (";") placement need to be.
Also, i have never worked with adding a RESIDENT tmp so does that belong on the top bottom, etc..... i provided an image of all the info of how i pull below..