By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Department | MinSalary | MaxSalary | EmployeesWithMin | EmployeesWithMax |
---|---|---|---|---|
Accounts | 40000.00 | 50000.00 | 2 | 1 |
IT | 20000.00 | 50000.00 | 1 | 2 |
Warning: Null value is eliminated by an aggregate or other SET operation.