What are the department ids, full names, and salaries for employees who make the most in their departments?
select first_name, last_name, salary, department_id, max(salary) from employees group by department_id