👯 Querying on Potential Twins

Here is an easy way to identify potential (likely) twins in your instance. By starting on the Person base, and then added an Independent Subquery for Person, we can compare the row that is being returned across all rows in the Person base. So if birthdates and last names match, but first names don't, we can assume that this may be a set of twins.

Importantly, we also want to exclude when a record matches itself; otherwise every record would be returned!

Suitcase: a4714b37-b60e-4d60-a8f3-2f2a8db48e75:rwf