By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table companies(
companyId int,
companyName varchar(100)
);
create table works (
workId int,
companyId int,
salary decimal(14,4)
)
insert into companies values (1,'one'),(2,'two'),(3,'three')
insert into works values (1,1,12345),(2,2,11111),(3,3,22222),(4,1,33333),(5,2,23456),(6,3,22222)
with sums as (select companies.companyId, companyname, sum(salary) AS sumsal
from works
join companies on companies.companyId=works.companyID
group by companies.companyId, companyname
)
select *
from sums
where sumsal=(select min(sumsal) from sums)
| companyId | companyname | sumsal |
|---|---|---|
| 2 | two | 34567.0000 |
with sums as (select companies.companyId, companyname, sum(salary) AS sumsal
from works
join companies on companies.companyId=works.companyID
group by companies.companyId, companyname
)
select *
from sums
where not exists (select * from sums s2 where s2.sumsal<sums.sumsal)
| companyId | companyname | sumsal |
|---|---|---|
| 2 | two | 34567.0000 |