Only show the latest date in a selection of data

I'm having problems using the MaxDate function in SQL and wondered if you could please help me?

I have the following scenario whereby a ContactID field can appear several times and yet have different lines of SQL that show different renewal dates. This is for a membership organisation that has a different renewal date each year, just so you get the picture. So, I might have something like this:

I'm having problems using the MaxDate function in SQL and wondered if you could please help me?

I have the following scenario whereby a ContactID field can appear several times and yet have different lines of SQL that show different renewal dates. This is for a membership organisation that has a different renewal date each year, just so you get the picture. So, I might have something like this: