explain the process and logic

Q3. The hierarchical data in tables store relations such as one column refers to other column in same table. For example, an entire family tree can be stored in a person table. The table below can identify the eldest ancestor(s) in a family. These people do not have ancestor data in their records, which means they form the root of the family tree. Write a query to retrieve the first and last name of each person along with the first and last name of their mother and father. ID 1 2 6 Noo 7 8 First name John Anne Scarlet Jacob David Last name Watson Brown Miller Miller Miller birth 1945 1950 1985 1982 2015 Mother id NULL NULL 2 NULL 6 Father id NULL NULL 1 NULL 7