By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table Employee_table (employee varchar(50),id int);
insert into Employee_table values ('A',1);
insert into Employee_table values ('A',1);
insert into Employee_table values ('B',2);
insert into Employee_table values ('D',4);
insert into Employee_table values ('B',2);
create table Salary_table (id int, salary int);
insert into Salary_table values (1,1250);
insert into Salary_table values (1,254);
insert into Salary_table values (3,434);
insert into Salary_table values (4,1200);
insert into Salary_table values (1,124);
Select employee,coalesce(sum(salary),0) Salary from Employee_table e
left join Salary_table s
on e.id = s.id
group by employee
order by sum(salary) desc limit 3
| employee | Salary |
|---|---|
| A | 3256 |
| D | 1200 |
| B | 0 |