SELECT m.ID, m.Name
FROM MEMBER m, PLAYER p, HOMECLUB h
WHERE m.ID = p.ID
AND p.HomeClubName = h.Name
AND h.Country = 'England'
AND m.ID IN (
SELECT q.ID
FROM MEMBER q, TEAMMEMBER t, TEAM e
WHERE q.ID = t.MemberID
AND e.ID = t.TeamID
AND e.Country = 'Australia');