Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE SIEM_DETAILS  
( ENTRY_ID number(10),  
  QUANTITY1 number(10),  
  QUANTITY2 number(10), 
  QUANTITY3 number(10), 
  QUANTITY4 number(10),   
  year number(4)
);
CREATE TABLE REAP_DETAILS  
( ENTRY_ID number(10),  
  QUANTITY5 number(10) ,  
  QUANTITY6 number(10) , 
  QUANTITY7 number(10) , 
  QUANTITY8 number(10) 
);
--INSERT INTO SIEM_DETAILS (ENTRY_ID, QUANTITY1, QUANTITY2, QUANTITY3, QUANTITY4, year) VALUES (001, 234, 21, 42, 4006, 1987);

--INSERT INTO SIEM_DETAILS (ENTRY_ID, QUANTITY1, QUANTITY2, QUANTITY3, QUANTITY4, year) VALUES (002, 467, 54, 87, 6554, 1988);

INSERT INTO SIEM_DETAILS (ENTRY_ID, QUANTITY1, QUANTITY2, QUANTITY3, QUANTITY4, year) VALUES (3, 474, 76, 87, 2456, 1989);
1 rows affected

--INSERT INTO REAP_DETAILS (ENTRY_ID, QUANTITY5, QUANTITY6, QUANTITY7, QUANTITY8) VALUES (001, 096, 01, 11, 8906);

--INSERT INTO REAP_DETAILS (ENTRY_ID, QUANTITY5, QUANTITY6, QUANTITY7, QUANTITY8) VALUES (002, 986, 74, 88, 8954);

INSERT INTO REAP_DETAILS (ENTRY_ID, QUANTITY5, QUANTITY6, QUANTITY7, QUANTITY8) VALUES (003, 565, 96, 89, 2756);
1 rows affected

INSERT INTO SIEM_DETAILS (ENTRY_ID, QUANTITY1, QUANTITY2, QUANTITY3, QUANTITY4, year) VALUES (69, 4704, 706, 807, 20456, 1980);
1 rows affected

INSERT INTO REAP_DETAILS (ENTRY_ID, QUANTITY5, QUANTITY6, QUANTITY7, QUANTITY8) VALUES (90, 5605, 906, 899, 27056);
1 rows affected

INSERT INTO SIEM_DETAILS (ENTRY_ID, QUANTITY1, QUANTITY2, QUANTITY3, QUANTITY4, year) VALUES (19, 4704, 706, 807, 20456, 1980);
1 rows affected

INSERT INTO REAP_DETAILS (ENTRY_ID, QUANTITY5, QUANTITY6, QUANTITY7, QUANTITY8) VALUES (40, 5605, 906, 899, 27056);
1 rows affected

INSERT INTO SIEM_DETAILS (ENTRY_ID, QUANTITY1, QUANTITY2, QUANTITY3, QUANTITY4, year) VALUES (169, 4704, 706, 807, 20456, 1980);
1 rows affected

SELECT * FROM SIEM_DETAILS;


ENTRY_ID
QUANTITY1
QUANTITY2
QUANTITY3
QUANTITY4
YEAR


3
474
76
87
2456
1989

69
4704
706
807
20456
1980

19
4704
706
807
20456
1980

169
4704
706
807
20456
1980


SELECT 
	SA.YEAR,			
  sum(SA.QUANTITY1),   						
  sum(SA.QUANTITY2),  		
  sum(SA.QUANTITY3),   
  sum(SA.QUANTITY4),  
  sum(CD.QUANTITY5),   
  sum(CD.QUANTITY6),
  sum(CD.QUANTITY7),  
  sum(CD.QUANTITY8)

FROM SIEM_DETAILS SA, REAP_DETAILS CD


GROUP BY SA.YEAR; 


YEAR
SUM(SA.QUANTITY1)
SUM(SA.QUANTITY2)
SUM(SA.QUANTITY3)
SUM(SA.QUANTITY4)
SUM(CD.QUANTITY5)
SUM(CD.QUANTITY6)
SUM(CD.QUANTITY7)
SUM(CD.QUANTITY8)


1989
1422
228
261
7368
11775
1908
1887
56868

1980
42336
6354
7263
184104
35325
5724
5661
170604

ENTRY_ID	QUANTITY1	QUANTITY2	QUANTITY3	QUANTITY4	YEAR
3	474	76	87	2456	1989
69	4704	706	807	20456	1980
19	4704	706	807	20456	1980
169	4704	706	807	20456	1980

YEAR	SUM(SA.QUANTITY1)	SUM(SA.QUANTITY2)	SUM(SA.QUANTITY3)	SUM(SA.QUANTITY4)	SUM(CD.QUANTITY5)	SUM(CD.QUANTITY6)	SUM(CD.QUANTITY7)	SUM(CD.QUANTITY8)
1989	1422	228	261	7368	11775	1908	1887	56868
1980	42336	6354	7263	184104	35325	5724	5661	170604