By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE PROJECTSWORKS(
PROJET_ID INT,
WORK_ID INT,
MAIN_WORK_ID INT,
WORK_NAME VARCHAR(30)
);
INSERT INTO PROJECTSWORKS VALUES
(1, 10, 1, 'Building-01');
SELECT * FROM PROJECTSWORKS;
| PROJET_ID | WORK_ID | MAIN_WORK_ID | WORK_NAME |
|---|---|---|---|
| 1 | 10 | 1 | Building-01 |
CREATE TABLE tab3(
ACTIVITY_ID INT,
PROJET_ID INT,
ACTIVITY_COST INT
);
INSERT INTO tab3 VALUES
(1, 1, 500),
(1, 1, 750),
(2, 1, 350);
SELECT * FROM tab3;
| ACTIVITY_ID | PROJET_ID | ACTIVITY_COST |
|---|---|---|
| 1 | 1 | 500 |
| 1 | 1 | 750 |
| 2 | 1 | 350 |
SELECT tab1.WORK_ID, SUM(tab3.ACTIVITY_COST)
FROM PROJECTSWORKS tab1
INNER JOIN tab3
ON tab1.PROJET_ID = tab3.PROJET_ID
WHERE tab1.PROJET_ID = 1
GROUP BY tab1.WORK_ID
| WORK_ID | (No column name) |
|---|---|
| 10 | 1600 |