Postgres 14

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

CREATE TABLE Jobs (JobId int, 
                   JobName varchar);
INSERT INTO Jobs (JobId, JobName) 
VALUES
  (1,'Job 1'),
  (2,'Job 2');
  
CREATE TABLE Levels (LevelId int, 
                     JobId int,
                     LevelName varchar);
INSERT INTO Levels (LevelId, JobId, LevelName) 
VALUES
  (1, 1, 'Job 1 Level 1'),
  (2, 1, 'Job 1 Level 2'),
  (3, 2, 'Job 2 Level 1');
  
  
CREATE TABLE SubLevels (SubLevelId int, 
                        LevelId int, 
                        SubLevelName varchar);
INSERT INTO SubLevels (SubLevelId, LevelId, SubLevelName) 
VALUES
  (1, 1, 'Level 1 Sub 1'),
  (2, 1, 'Level 1 Sub 2'),
  (3, 2, 'Level 2 Sub 1'),
  (4, 2, 'Level 2 Sub 2'),
  (5, 3, 'Job 2 Level 1 Sub 1');
  
  
CREATE TABLE DoorTasks(TaskId int,
                       SubLevelId int,
                       TaskName varchar,
                       EstimatedHours int);

INSERT INTO DoorTasks(TaskId, SubLevelId, TaskName, EstimatedHours) VALUES
  (1, 1, 'Job 1 Door Task 1', 5),
  (2, 1, 'Job 1 Door Task 2', 5),
  (3, 1, 'Job 1 Door Task 3', 5),
  (4, 2, 'Job 1 Door Task 4', 5),
  (5, 5, 'Job 2 Door Task 5', 1);
  
    
CREATE TABLE DoorFrameTasks(TaskId int,
                       SubLevelId int,
                       TaskName varchar,
                       EstimatedHours int);

INSERT INTO DoorFrameTasks(TaskId, SubLevelId, TaskName, EstimatedHours) VALUES
  (1, 1, 'Job 1 Door Frame Task 1', 5),
  (2, 1, 'Job 1 Door Frame Task 2', 5),
  (3, 1, 'Job 1 Door Frame Task 3', 5),
  (4, 2, 'Job 1 Door Frame Task 4', 5),
  (5, 5, 'Job 2 Door Frame Task 5', 2);
  
    
CREATE TABLE DoorHardwareTasks(TaskId int,
                       SubLevelId int,
                       TaskName varchar,
                       EstimatedHours int);

INSERT INTO DoorHardwareTasks(TaskId, SubLevelId, TaskName, EstimatedHours) VALUES
  (1, 1, 'Job 1 Door Frame Task 1', 5),
  (2, 1, 'Job 1 Door Frame Task 2', 5),
  (3, 1, 'Job 1 Door Frame Task 3', 5),
  (4, 5, 'Job 2 Door Frame Task 4', 3),
  (5, 5, 'Job 2 Door Frame Task 5', 4);

2 rows affected

3 rows affected

5 rows affected

5 rows affected

5 rows affected

5 rows affected

jobid	jobname	sum
1	Job 1	55
2	Job 2	10