rdz555 0 Newbie Poster

consider 5 subjects : A, B, C, D and E.

subject A is the father of the subject B.

Subject C is the brother of the subject B.

subject D is the son of the subject B.
subject E is the son of the subject C.


Write a stored procedure that takes as parameters two of the 5 subjects and return their family kinship.