SELECT first_name ,  last_name ,  department_id FROM employees WHERE salary IN (SELECT MIN(salary) FROM employees GROUP BY department_id)
What are the full names and department ids for the lowest paid employees across all departments.
SELECT first_name , last_name , department_id FROM employees WHERE salary IN ( SELECT MIN ( salary ) FROM employees GROUP BY department_id )
select first_name , last_name , department_id from employees where salary in ( select min ( salary ) from employees group by department_id )
What are the full names and department ids for the lowest paid employees across all departments .