The 'Euro' World Cup

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

Cypher query

MATCH (p)-[b:Born_in]-(n)-[r:Worth]-(v:Value)where v.Value_euros >= 38000000RETURN p,b,norder by v.Value_euros desc

Cypher query

MATCH (p)-[b:Also_plays_for]-(n)-[r:Worth]-(v:Value)return distinct n.Player as Player, v.Value_euros as ValuesORDER by Values DESClimit 100

Cypher query

MATCH (p)-[b:Also_plays_for]-(n)-[r:Worth]-(v:Value)where v.Value_euros >= 38000000 return distinct p.FIFA_REP_CLUB_NAME as Clubsorder by p.FIFA_REP_CLUB_NAME

Cypher query

MATCH (p)-[b:Also_plays_for]-(n)-[r:Worth]-(v:Value)where v.Value_euros >= 38000000 and p.Continent_current_team is not nullreturn distinct p.Continent_current_team as Continent_of_the_club, p.Country_of_current_team, count (p) as Number_of_Playersorder by Number_of_Players desc

Cypher query

MATCH (p)-[b:Also_plays_for]-(n)-[r:Worth]-(v:Value)where v.Value_euros >= 38000000 and n.Age is not nullreturn n.Age as Age, count (distinct n.Player) as Sum_of_playersorder by Age desc

Cypher query

MATCH (p:Player)-[r:Represents]->(n)where p.Country_of_birth <> n.National_teamreturn n.National_team, count(distinct p) as players order by players desc

Cypher query

MATCH (c)-[j:Also_plays_for]-(p)-[r:Represents]-(n)return c.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_teamORDER BY Players DESC

Cypher query

MATCH (a)-[b:Situated_in]-(c:Clubs)-[j:Also_plays_for]-(p:Player)-[r:Represents]-(n:National_team)return count(p) as players, a.National_team as continent_of_clubs, n.Continent_Region as continent_of_national_teamsorder by players desc

Page updated

Google Sites

Report abuse