SELECT genus, species, continent ; 
    FROM Species ;
    INNER JOIN Site S ON S.fkey =Species.Pkey AND S.continent IN ('Africa','Asia');
    INNER JOIN Site X ON X.fkey =Species.Pkey AND X.continent IN ('Africa','Asia') AND X.continent#S.continent ;
ORDER BY 1,2