GraphGists

英格兰成年队参加2016年RBS六国橄榄球赛和精英球员名单

版本 0.1,2016年1月13日

六国赛的训练名单于1月13日下午2点公布,此图显示了入选名单的球员、他们所在的国内俱乐部以及因伤替补的球员。

设置

MATCH (n) RETURN n

名单中有多少球员?

match (c:Club)<-[r:PLAYS_FOR]-(p:Player)-[*2..2]-(s:Squad)
where s.name = '6 Nations 2016'
return count(r) as players;

哪个超级联赛球队入选的球员最多?

match (c:Club)<-[r:PLAYS_FOR]-(p:Player)-[*2..2]-(s:Squad)
where s.name = '6 Nations 2016'
return c.name as club, count(r) as players
order by players desc, club asc;

哪些球员尚未获得国家队出场资格?

match (p:Player)-[*2..2]-(s:Squad)
where s.name = '6 Nations 2016'
and p.caps = 0
return p.name as uncapped;

谁是因伤替补的球员?

match (m)-[:INJURY_REPLACEMENT_FOR]->(n)
return m.name as substitutes, n.name as injured;
© . All rights reserved.