Из временной таблицы в временную таблицу

CREATE OR REPLACE FUNCTION historical_data() RETURNS TABLE(name VARCHAR, "number" int) AS
$$
 
DROP TABLE IF EXISTS A; CREATE temp TABLE A AS
 
 
SELECT tickers.name, (COALESCE(COUNT(a1401.TYPE), 0)+COALESCE(COUNT(a1402.TYPE), 0)+COALESCE(COUNT(a1403.TYPE), 0)+COALESCE(COUNT(a1404.TYPE), 0)
+COALESCE(COUNT(a1405.TYPE), 0)+COALESCE(COUNT(a1406.TYPE), 0)) AS "number" 
FROM tickers 
left join topics t ON t.id = tickers.topic_id
left join articles_y2014m01 a1401 ON t.id = ANY(a1401.topic_ids) AND a1401.TYPE NOT LIKE 'Tweet'
left join articles_y2014m02 a1402 ON t.id = ANY(a1402.topic_ids) AND a1402.TYPE NOT LIKE 'Tweet'
....
....
....
....
....
DROP TABLE IF EXISTS B;CREATE temp TABLE B AS
 
SELECT tickers.name, (COALESCE(COUNT(a1407.TYPE), 0)+COALESCE(COUNT(a1408.TYPE), 0)+COALESCE(COUNT(a1409.TYPE), 0)
+COALESCE(COUNT(a1410.TYPE), 0)+COALESCE(COUNT(a1411.TYPE), 0)+COALESCE(COUNT(a1412.TYPE), 0)) AS "number" 
FROM tickers 
left join topics t ON t.id = tickers.topic_id
left join articles_y2014m07 a1407 ON t.id = ANY(a1407.topic_ids) AND a1407.TYPE NOT LIKE 'Tweet'
left join articles_y2014m08 a1408 ON t.id = ANY(a1408.topic_ids) AND a1408.TYPE NOT LIKE 'Tweet'
....
....
....
....
....
 
DROP TABLE IF EXISTS C;CREATE temp TABLE C AS   
 
SELECT A.name, (А."number"+B."number") AS number_14 FROM A
FULL OUTER JOIN  B ON A.name = B.name
GROUP BY А.name;
....
....
....
....
....
DROP TABLE IF EXISTS his_data;CREATE temp TABLE his_data AS 
 
SELECT C.name, (C.number_14 + D.number_15 + E.number_16) AS count_number FROM C
FULL OUTER JOIN  D ON C.name = D.name
FULL OUTER JOIN  E ON D.name = E.name
GROUP BY C.name;
SELECT * FROM his_data;
$$ LANGUAGE SQL VOLATILE;

CREATE temp TABLE;