Write a query that retrieves a list of all employees whose salary is higher than the salary of their department manager. The result should contain the following columns EMP_NO, FIRST_NAME, LAST_NAME - employee data, DEPARTMENT - the name of the department in which he works, SALARY - his salary, MANAGER_SALARY - department manager salary. Sort the result by EMP_NO in default order.
Write your request in the field below and click the "Check it!" button.
Use Firebird syntax to write your answer. Descriptions of tables are provided at the bottom of the screen.
