Write a SQL query that displays relation between parent and child from the following table

Geography table

SKGeographyID	Geography	SKParentGeographyID
1	Europe	NULL
2	America	NULL
3	Undisclosed	NULL
4	Hong Kong	1
5	New Zealand	2
6	Singapore	1
7	Malaysia	2
8	Japan	3
9	Brazil	3

 
Select A.Geography, (SELECT Geography
FROM DW.DimGeography B WHERE B.SkGeographyId = A.SkParentGeographyId ) FROM DW.DimGeography A