display the department ID, full name (first and last name), salary for those employees who is highest salary in every department.
SELECT first_name ,   last_name ,   salary ,  department_id ,  MAX(salary) FROM employees GROUP BY department_id
SELECT first_name ,   last_name ,   salary ,  department_id ,  MAX(salary) FROM employees GROUP BY department_id
[{'FIRST_NAME': 'Kimberely', 'LAST_NAME': 'Grant', 'SALARY': 7000, 'DEPARTMENT_ID': 0, 'MAX(salary)': 7000}, {'FIRST_NAME': 'Jennifer', 'LAST_NAME': 'Whalen', 'SALARY': 4400, 'DEPARTMENT_ID': 10, 'MAX(salary)': 4400}, {'FIRST_NAME': 'Michael', 'LAST_NAME': 'Hartstein', 'SALARY': 13000, 'DEPARTMENT_ID': 20, 'MAX(salary)': 13000}, {'FIRST_NAME': 'Den', 'LAST_NAME': 'Raphaely', 'SALARY': 11000, 'DEPARTMENT_ID': 30, 'MAX(salary)': 11000}, {'FIRST_NAME': 'Susan', 'LAST_NAME': 'Mavris', 'SALARY': 6500, 'DEPARTMENT_ID': 40, 'MAX(salary)': 6500}, {'FIRST_NAME': 'Adam', 'LAST_NAME': 'Fripp', 'SALARY': 8200, 'DEPARTMENT_ID': 50, 'MAX(salary)': 8200}, {'FIRST_NAME': 'Alexander', 'LAST_NAME': 'Hunold', 'SALARY': 9000, 'DEPARTMENT_ID': 60, 'MAX(salary)': 9000}, {'FIRST_NAME': 'Hermann', 'LAST_NAME': 'Baer', 'SALARY': 10000, 'DEPARTMENT_ID': 70, 'MAX(salary)': 10000}, {'FIRST_NAME': 'John', 'LAST_NAME': 'Russell', 'SALARY': 14000, 'DEPARTMENT_ID': 80, 'MAX(salary)': 14000}, {'FIRST_NAME': 'Steven', 'LAST_NAME': 'King', 'SALARY': 24000, 'DEPARTMENT_ID': 90, 'MAX(salary)': 24000}, {'FIRST_NAME': 'Nancy', 'LAST_NAME': 'Greenberg', 'SALARY': 12000, 'DEPARTMENT_ID': 100, 'MAX(salary)': 12000}, {'FIRST_NAME': 'Shelley', 'LAST_NAME': 'Higgins', 'SALARY': 12000, 'DEPARTMENT_ID': 110, 'MAX(salary)': 12000}]