GML Top 100: Avg. Field Position |
RANK | PLAYER | Avg. Field Position | TEAMSELECT last_name as lastname, first_name as firstname, nickname, s.playerid, sum(averagefieldpositionafterkickoff)/sum(kickoffs) AS leader, yearretired, h.position, a.team, min(year) AS firstyear
FROM statsbyseason s
JOIN fof7_player_information h ON h.player_id=s.playerid
LEFT JOIN fof7_player_record a ON a.player_id=s.playerid
LEFT JOIN ben_retired r on r.playerid=s.playerid
WHERE last_name<>""
GROUP BY s.playerid
HAVING sum(kickoffs)>99
ORDER BY leader LIMIT 100 Unknown column 'averagefieldpositionafterkickoff' in 'field list' |
|