Hi @Darrin N , Really sorry for just noticing your post. If you still need the SQL please find it in the attached file. Best Regards, Mike

Thank you Santosh! Taking time to rethink my approach, removing the full_name was an effective way to solve the problem. It was partly a data issue because there are history rows where the full name is different (cancelling out the effect of the DISTINCT statement). I substituted the last name instead, which works just…