The query is to return the latest next_contact date for each person. Using the max() aggregate function and modeling the example of lo_temp on page 13 of the rel. 10 manual I wrote this statement:
I use DISTINCT ON and ORDER BY to get the single latest value from a table with multiple date entries: