Question

Write an Oracle SQL query to find the names of employees not assigned to any project.

Answer 1

SELECT employee_name

FROM employees

WHERE employee_id NOT IN (SELECT DISTINCT employee_id FROM projects);