SELECT GP$1.$Name AS GrandFather, GP$2.$Name AS GrandMother, Grandson.Name AS Grandson

FROM Parent Pa$1$

JOIN Parent Pa$2$ ON Pa$1.$ChildID $=$ Pa$2.$ParentID AND Pa$1.$ParentID $!=$ Pa$2.$ParentID

JOIN Person GP$1$ ON Pa$1.$ParentID $=$ GP$1.$PersonID

JOIN Person GP$2$ ON Pa$1.$ParentID $=$ GP$2.$PersonID

JOIN Person Grandson ON Pa$2.$ChildID $=$ Grandson.PersonID

WHERE GP$1.$Name $<$ GP$2.$Name, GP$1.$Gender $=\text{'}$M$\text{'}$ AND GP$2.$Gender $=\text{'}$F$\text{'}$;

How do I get the SQL Query to return the table with Grandfathers and Grandmothers in their own columns and show the grandsons $??$