CREATE TABLE t1(id SERIAL PRIMARY KEY,
			 fio VARCHAR);

CREATE TABLE t2(id INTEGER NOT NULL REFERENCES t1(id),
			 f2 DOUBLE PRECISION);
			
CREATE TABLE t3(id INTEGER NOT NULL REFERENCES t1(id),
			 f3 DOUBLE PRECISION); 

-- Ввод данных

INSERT INTO t1(id,fio) VALUES (1,'Petrov');
INSERT INTO t1(id,fio) VALUES (2,'Ivanov');
INSERT INTO t1(id,fio) VALUES (3,'Smirnov');

INSERT INTO t2(id,f2) VALUES (1,100);

INSERT INTO t3(id,f3) VALUES(1,30);
INSERT INTO t3(id,f3) VALUES(2,55);
INSERT INTO t3(id,f3) VALUES(2,38);
INSERT INTO t3(id,f3) VALUES(2,45);
INSERT INTO t3(id,f3) VALUES(3,55);
INSERT INTO t3(id,f3) VALUES(3,45);
INSERT INTO t3(id,f3) VALUES(3,85);

-- Запрос 1
SELECT 
	fio,
	SUM(f2) as sum_f2
FROM t1	
INNER JOIN t2 ON t1.id=t2.id
GROUP BY fio;	

-- Запрос 2

SELECT 
	fio,
	SUM(f3) as sum_f3
FROM t1	
INNER JOIN t3 ON t1.id=t3.id
GROUP BY fio;