RelativeTech

select p.project_name, w.worker_name

from project p, worker w, project_worker_map m
where m.project_id = p.id

and m.worker_id = w.id

RelativeTech

select max(compensation) as Max
from worker


select min(compensation) as Min
from worker

RelativeTech

select project_worker_map.project_id, sum(worker.compensation)
from worker, project_worker_map
where worker = project_worker_map.worker_id
group by project_id
having sum(worker.compensation) > 500000

RelativeTech

select p.project_id, sum(w.compensation) as TotalComp
from worker w, project_worker_map p
where  = p.worker_id
group by project_id
having sum(w.compensation) > 500000

RelativeTech

select p.project_id, sum(w.compensation) as TotalComp
from worker w, project_worker_map p
where  = p.worker_id
group by project_id

RelativeTech

select some_field
from some_table
group by some_field
having count(some_field) > 1

RelativeTech

select project_id, count(worker_id) as Worker_Count
from project_worker_map
group by project_id
having count(worker_id) > 2

RelativeTech

select project_id, count(worker_id) as WorkerCount
from project_worker_map
group by project_id

RelativeTech

update worker
set compensation = 200000,
worker_code = 'CODE-X'
where id = 3

RelativeTech

INSERT INTO WORKER(ID, AUDIT_ID, WORKER_CODE, WORKER_NAME, COMPENSATION)
VALUES(1, '00000000-0000-0000-0000-000000000001', 'CODE-1', 'One First', 120000.00);