Getting employees with the highest salary in each department

livecode

Task condition

It is necessary to form a list of employees receiving the highest salary within their department.

ID NUMBER,
NAME VARCHAR(256),
SALARY NUMBER, 
DEPARTMENT_ID NUMBER, 
CHIEF_ID NUMBER
);