Selection of employees earning more than their managers

livecode

Task condition

Get a list of employees whose salary exceeds that of their immediate supervisor.

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