Find the first name and last name and department id for those employees who earn such amount of salary which is the smallest salary of any of the 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)
[{'FIRST_NAME': 'Neena', 'LAST_NAME': 'Kochhar', 'DEPARTMENT_ID': 90}, {'FIRST_NAME': 'Lex', 'LAST_NAME': 'De Haan', 'DEPARTMENT_ID': 90}, {'FIRST_NAME': 'Bruce', 'LAST_NAME': 'Ernst', 'DEPARTMENT_ID': 60}, {'FIRST_NAME': 'Diana', 'LAST_NAME': 'Lorentz', 'DEPARTMENT_ID': 60}, {'FIRST_NAME': 'Luis', 'LAST_NAME': 'Popp', 'DEPARTMENT_ID': 100}, {'FIRST_NAME': 'Karen', 'LAST_NAME': 'Colmenares', 'DEPARTMENT_ID': 30}, {'FIRST_NAME': 'Shanta', 'LAST_NAME': 'Vollman', 'DEPARTMENT_ID': 50}, {'FIRST_NAME': 'James', 'LAST_NAME': 'Marlow', 'DEPARTMENT_ID': 50}, {'FIRST_NAME': 'TJ', 'LAST_NAME': 'Olson', 'DEPARTMENT_ID': 50}, {'FIRST_NAME': 'Joshua', 'LAST_NAME': 'Patel', 'DEPARTMENT_ID': 50}, {'FIRST_NAME': 'Peter', 'LAST_NAME': 'Vargas', 'DEPARTMENT_ID': 50}, {'FIRST_NAME': 'Peter', 'LAST_NAME': 'Tucker', 'DEPARTMENT_ID': 80}, {'FIRST_NAME': 'Oliver', 'LAST_NAME': 'Tuvault', 'DEPARTMENT_ID': 80}, {'FIRST_NAME': 'Janette', 'LAST_NAME': 'King', 'DEPARTMENT_ID': 80}, {'FIRST_NAME': 'Sarath', 'LAST_NAME': 'Sewall', 'DEPARTMENT_ID': 80}, {'FIRST_NAME': 'Harrison', 'LAST_NAME': 'Bloom', 'DEPARTMENT_ID': 80}, {'FIRST_NAME': 'Sundita', 'LAST_NAME': 'Kumar', 'DEPARTMENT_ID': 80}, {'FIRST_NAME': 'Kimberely', 'LAST_NAME': 'Grant', 'DEPARTMENT_ID': 0}, {'FIRST_NAME': 'Martha', 'LAST_NAME': 'Sullivan', 'DEPARTMENT_ID': 50}, {'FIRST_NAME': 'Nandita', 'LAST_NAME': 'Sarchand', 'DEPARTMENT_ID': 50}, {'FIRST_NAME': 'Randall', 'LAST_NAME': 'Perkins', 'DEPARTMENT_ID': 50}, {'FIRST_NAME': 'Jennifer', 'LAST_NAME': 'Whalen', 'DEPARTMENT_ID': 10}, {'FIRST_NAME': 'Pat', 'LAST_NAME': 'Fay', 'DEPARTMENT_ID': 20}, {'FIRST_NAME': 'Susan', 'LAST_NAME': 'Mavris', 'DEPARTMENT_ID': 40}, {'FIRST_NAME': 'Hermann', 'LAST_NAME': 'Baer', 'DEPARTMENT_ID': 70}, {'FIRST_NAME': 'William', 'LAST_NAME': 'Gietz', 'DEPARTMENT_ID': 110}]