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
``` yaml
employees: # name of dataframe
- EMPLOYEE_ID:
    dtype: int64
    sample_values: 100, 101, 102
- FIRST_NAME:
    dtype: string
    sample_values: Steven, Neena, Lex
- LAST_NAME:
    dtype: string
    sample_values: King, Kochhar, De Haan
- EMAIL:
    dtype: string
    sample_values: SKING, NKOCHHAR, LDEHAAN
- PHONE_NUMBER:
    dtype: string
    sample_values: 515.123.4567, 515.123.4568, 515.123.4569
- HIRE_DATE:
    dtype: datetime
    sample_values: 1987-06-17, 1987-06-18, 1987-06-19
- JOB_ID:
    dtype: string
    sample_values: AD_PRES, AD_VP, AD_VP
- SALARY:
    dtype: int64
    sample_values: 24000, 17000, 17000
- COMMISSION_PCT:
    dtype: float64
    sample_values: 0.0, 0.0, 0.0
- MANAGER_ID:
    dtype: int64
    sample_values: 0, 100, 100
- DEPARTMENT_ID:
    dtype: int64
    sample_values: 90, 90, 90

```
FIRST_NAME,LAST_NAME,SALARY,DEPARTMENT_ID,MAX(salary)
Kimberely,Grant,7000,0,7000
Jennifer,Whalen,4400,10,4400
Michael,Hartstein,13000,20,13000
Den,Raphaely,11000,30,11000
Susan,Mavris,6500,40,6500
Adam,Fripp,8200,50,8200
Alexander,Hunold,9000,60,9000
Hermann,Baer,10000,70,10000
John,Russell,14000,80,14000
Steven,King,24000,90,24000
Nancy,Greenberg,12000,100,12000
Shelley,Higgins,12000,110,12000
