EPL teams by average squad age

EPL teams by average squad age

Post by Alkamist » Fri, 05 Apr 2013 06:01:32


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

EPL teams by average squad age

Post by MH » Fri, 05 Apr 2013 06:12:12


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

Post by Alkamist » Fri, 05 Apr 2013 06:18:23


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

Post by Ammammat » Fri, 05 Apr 2013 08:10:27

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

Post by Alkamist » Fri, 05 Apr 2013 08:16:56


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

Check (Propeller_Heads) = True;
 
 
 

EPL teams by average squad age

Post by Jesus Petr » Fri, 05 Apr 2013 23:04:29

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