Выбрать максимальную зарплату продавцов (код должности - 670) по каждому отделу.

1) select (max(Salary)), Department.Name
from employee, Department
where employee.Department_ID = Department.Department_ID
and job_id = 670
GROUP BY Department.Name
2) select *
from employee
order by first_name, last_name
3) select Name.Department, Regional_Group.Location
from Department inner join Department.Location_ID=Location.Location_ID