
/* Code Fragment 5.2 What is Bob's current position ? */

SELECT JOB_TITLE_CODE1
FROM EMPLOYEES, INCUMBENTS, POSITIONS
WHERE FIRST_NAME = 'Bob'
AND EMPLOYEES.SSN = INCUMBENTS.SSN
AND INCUMBENTS.PCN = POSITIONS.PCN
AND START_DATE <= GETDATE()
AND GETDATE() < END_DATE
