By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| ID | Name | Gender | Diagnosis_Class | Flag |
|---|---|---|---|---|
| ID_100 | John | Male | Primary | |
| ID_101 | David | Male | Primary | |
| ID_102 | Susan | Female | Primary | |
| ID_102 | Susan | Female | Related | Yes |
| ID_103 | Steve | Male | Primary | |
| ID_103 | Steve | Male | Related | Yes |
| ID_104 | Kevin | Male | Primary | |
| ID_105 | Peter | Male | Related | No |
| ID_106 | Ben | Male | Primary | |
| ID_107 | Sophie | Female | Related | No |