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