select b.[Contact ID],b.[Booking: Booking Number],b.[First Name],b.[Booking Passenger Email],a.DateSubmitted
from
(select SubscriberKey,max(Datesubmitted) as [DateSubmitted],Europe,Winter from [AUS mock Preference Centre - NO primary key]
group by SubscriberKey,Europe,Winter) as a
JOIN [MTP TT JB CRIS 2] as b
ON b.[Contact ID]=a.SubscriberKey
where (a.Europe='True' and a.Winter='True')