Although The FIFA World Cup brings together 32 national teams representing all continents, most of the 831 players play for European clubs. Among the 100 most valuable athletes in the tournament, all of them play for clubs from only 6 European countries
MATCH(c)-[j:Also_plays_for]-(p)-[r:Represents]-(n)returnc.FIFA_REP_CLUB_NAME as Club,count(p.Player)as Players,c.Country_of_current_team as Country_of_the_team,c.Continent_current_team as Continent_of_the_teamORDERBY Players DESC
Cypher query
MATCH(a)-[b:Situated_in]-(c:Clubs)-[j:Also_plays_for]-(p:Player)-[r:Represents]-(n:National_team)returncount(p)as players,a.National_team as continent_of_clubs, n.Continent_Region as continent_of_national_teamsorderby players desc