Return Max Date of a column independent of other columns

I have two tables like this:

Client Table (let's name it like ClientTable)

Travels Table (let's name it like TravelTable)

What I need is to catch John's latest trip (To Germany), regardless of what country he's been to. I wrote my SQL like this:

SELECT DISTINCT a.ContactID, a.Name, a.Email, MAX(b.TripDate) AS 'LastTrip', b.Country
FROM ClientTable a WITH (NOLOCK)
LEFT JOIN TravelTable b ON a.ContactID = b.ContactID
WHERE a.ContactID IS NOT NULL AND a.Email IS NOT NULL
GROUP BY a.ContactID, a.Name, a.Email, b.Country

The problem is that I getting this output:

| ContactID | Name | Email                 | LastTrip   | Country |
| --------- | ---- | --------------------- | ---------- | ------- |
| 001       | John | johnemail01@gmail.com | 2022-10-18 | Germany |
| 001       | John | johnemail01@gmail.com | 2022-03-07 | EUA     |

I really struggle with this one and don't get what I'm not doing to get just the last trip from John.

Thanks in advance.

You can use a subquery to get the MAX date:

SELECT 
  a.ContactID, 
  a.Name, 
  a.Email, 
  b.TripDate AS 'LastTrip', 
  b.Country
FROM ClientTable a WITH (NOLOCK)
LEFT JOIN TravelTable b ON a.ContactID = b.ContactID
WHERE a.ContactID IS NOT NULL 
  AND a.Email IS NOT NULL
  AND b.TripDate = (SELECT MAX(c.TripDate) 
                    FROM TravelTable c)

Result:

| ContactID | Name | Email                 | LastTrip   | Country |
|-----------|------|-----------------------|------------|---------|
| 1         | John | johnemail01@gmail.com | 2022-10-18 | Germany |

Fiddle here.