Easy question, solved in 5 mins.
Only issue: did not rename the resule column as required in the question.
SELECT E.name as 'Employee' FROM
(Employee E JOIN Employee M
ON E.managerId = M.id)
WHERE E.salary > M.salary;
Easy question, solved in 5 mins.
Only issue: did not rename the resule column as required in the question.
SELECT E.name as 'Employee' FROM
(Employee E JOIN Employee M
ON E.managerId = M.id)
WHERE E.salary > M.salary;