Chapter 4 Exercise 1

1. Which employee still working for the store was hired the most recently?

SELECT Employee.EmployeeID, Employee.LastName, Employee.DateHired, Employee.DateReleased
FROM Employee
WHERE (((Employee.DateReleased) Is Null))
ORDER BY Employee.DateHired DESC;