Question

Display the maximum salary of each department.
select dept__name , max (salary)
from department, Employees
where department. dept__ no = Employee. dept__no.
group by dept__name;
​

Answer 1

Answer:

max is my answer for girl scouts