## EPL teams by average squad age

### EPL teams by average squad age

http://sphotos-a.xx.fbcdn.net/hphotos-ash3/553022_10151659552252573_1...

### EPL teams by average squad age

Quote:
> http://sphotos-a.xx.fbcdn.net/hphotos-ash3/553022_10151659552252573_1...

How is this calculated ?  I note there is a "games played" column.

So do they just take average age of all players listed in the squad, or
do they in fact take the average age of all game-day squads (or starting
11s ?) for each games day, add them all up, and divide by the number of
games ?

### EPL teams by average squad age

Quote:

> How is this calculated ? ?I note there is a "games played" column.

> So do they just take average age of all players listed in the squad, or
> do they in fact take the average age of all game-day squads (or starting
> 11s ?) for each games day, add them all up, and divide by the number of
> games ?

No clue, image published online by a Liverpool group I subscribe to.
The source is Opta statistics, might find more info on their site.

### EPL teams by average squad age

Il Thu, 04 Apr 2013 00:23:32 +0200, anders t ha scritto:

Quote:
> Something like perhaps:

> SELECT T.name AS Team,
>        ROUND(SUM(P.age) / COUNT(T.id)) AS [Weighted Average]
> FROM Player P, SquadItem S, Team T WHERE P.id = S.player AND S.team =
> T.id GROUP BY T.id, T.name

DROP TABLE T
COMMIT

--
/-\ /\/\ /\/\ /-\ /\/\ /\/\ /-\ T /-\

### EPL teams by average squad age

Quote:
> Il Thu, 04 Apr 2013 00:23:32 +0200, anders t ha scritto:

> > Something like perhaps:

> > SELECT T.name AS Team,
> > ? ? ? ?ROUND(SUM(P.age) / COUNT(T.id)) AS [Weighted Average]
> > FROM Player P, SquadItem S, Team T WHERE P.id = S.player AND S.team =
> > T.id GROUP BY T.id, T.name

> DROP TABLE T
> COMMIT

### EPL teams by average squad age

Quote:

> Il Thu, 04 Apr 2013 00:23:32 +0200, anders t ha scritto:

> > Something like perhaps:

> > SELECT T.name AS Team,
> >        ROUND(SUM(P.age) / COUNT(T.id)) AS [Weighted Average]
> > FROM Player P, SquadItem S, Team T WHERE P.id = S.player AND S.team =
> > T.id GROUP BY T.id, T.name

> DROP TABLE T
> COMMIT

Error: parent found!

Tchau!
Jesus Petry