display the department ID, full name (first and last name), salary for those employees who is highest salary in every department.
CREATE TABLE employees (
    first_name VARCHAR,
    last_name VARCHAR,
    salary INTEGER,
    department_id VARCHAR
)
SELECT first_name, last_name, salary, department_id, MAX(salary) FROM employees GROUP BY department_id
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: display the department ID, full name (first and last name), salary for those employees who is highest salary in every department. ### Input: CREATE TABLE employees (
    first_name VARCHAR,
    last_name VARCHAR,
    salary INTEGER,
    department_id VARCHAR
) ### Response: SELECT first_name, last_name, salary, department_id, MAX(salary) FROM employees GROUP BY department_id