Find employees with the maximum salary in his department. Display a table with columns DEPARTMENT - department name, EMP_NO, FIRST_NAME, LAST_NAME - employee data, SALARY - his salary. Sort the data in descending order of salary.
Write your request in the field below and click the "Check it!" button.
To write the answer, use Firebird syntax. Descriptions of the tables are given in the right panel.