i have a table which has a number of relationships between family members. I want to know if its possible to group them into family groups using this dataset.
fig 1. is the sample data
fig 2. is the type of output i'd like
is this possible using sql syntax?