I have two tables, say Users and Interviews. One user can have multiple interview records. 

```
Users
-----
UserID
FirstName
LastName

Interviews
----------
InterviewID
UserID
DateOfInterview

```

I want to get only the latest interview records. Here's my query

```
select u.UserID, firstname, lastname, max(DateOfInterview) as latestDOI 
from users u 
left join interviews i 
on u.UserID = i.UserID 
GROUP BY u.UserID, firstname, lastname
ORDER BY max(DateOfInterview) DESC

```

How do I update the query to return the InterviewID as well (i.e. the one which corresponds to max(DateOfInterview))?