Problem 16. Employees Maximum Salaries
Може ли помощ по тази заявка , по-скоро в тази част "max salaries NOT in the range 30000 – 70000."
Find the max salary for each department. Filter those, which have max salaries NOT in the range 30000 – 70000.
Example:
DepartmentID |
MaxSalary |
2 |
29800.00 |
… |
… |
Благодаря :)