
/* Code Fragment 5.4 What employees currently have no position? */

SELECT FIRST_NAME
FROM EMPLOYEES
WHERE NOT EXISTS (	SELECT INCUMBENTS.SSN
			FROM INCUMBENTS
			WHERE EMPLOYEES.SSN = INCUMBENTS.SSN
			AND START_DATE <= GETDATE()
			AND GETDATE() < END_DATE)
