-- Step 1: The current manager of the Development department ('d005') is retiring today. -- We must "close" their active record by changing their to_date to today. UPDATE dept_manager SET to_date = ...