|
Data updated through 2012 week 17
Click on a year-to-date ('YTD') or 'Last 3' column to sort. Click on a team to view game-by-game stats.
|
Team |
Avg Pts Yielded |
Avg Rush Pts Yielded |
Avg Pass Pts Yielded |
Unknown column 'PASS_TD4' in 'field list'
SELECT a.PLAYER_ID, AVG(PASS_YD) AS PASS_YD, AVG(PASS_INT) AS PASS_INT, AVG(FUMBLES_LOST) AS FUMBLES_LOST, AVG(PASS_ATT) AS PASS_ATT,AVG(PASS_COMP) AS PASS_COMP, AVG(SCORING_OPP) AS SCORING_OPP, AVG(REC_YD) AS REC_YD, AVG(RUSH_ATT) AS RUSH_ATT,AVG(RUSH_YD) AS RUSH_YD, AVG(REC_TARGET) AS REC_TARGET, AVG(REC) AS REC, AVG(PASS_TD1) AS PASS_TD1, AVG(PASS_TD2) AS PASS_TD2, AVG(PASS_TD3) AS PASS_TD3, AVG(PASS_TD4) AS PASS_TD4, AVG(PASS_TD5) AS PASS_TD5, AVG(PASS_TD6) AS PASS_TD6, AVG(RUSH_TD1) AS RUSH_TD1, AVG(RUSH_TD2) AS RUSH_TD2, AVG(RUSH_TD3) AS RUSH_TD3, AVG(RUSH_TD4) AS RUSH_TD4, AVG(RUSH_TD5) AS RUSH_TD5, AVG(RUSH_TD6) AS RUSH_TD6, AVG(REC_TD1) AS REC_TD1, AVG(REC_TD2) AS REC_TD2, AVG(REC_TD3) AS REC_TD3, AVG(REC_TD4) AS REC_TD4, AVG(REC_TD5) AS REC_TD5, AVG(REC_TD6) AS REC_TD6, AVG(PASS_TD1 + PASS_TD2 + PASS_TD3 + PASS_TD4 + PASS_TD5 + PASS_TD6) AS PASS_TD, AVG(RUSH_TD1 + RUSH_TD2 + RUSH_TD3 + RUSH_TD4 + RUSH_TD5 + RUSH_TD6) AS RUSH_TD, AVG(REC_TD1 + REC_TD2 + REC_TD3 + REC_TD4 + REC_TD5 + REC_TD6) AS REC_TD FROM stats_yielded_off a WHERE a.SEGMENT_ID >= 436 AND a.SEGMENT_ID <= 452 AND a.PLAYER_ID = 1 AND a.POSITION_ID = 1 GROUP BY PLAYER_ID |
Friend Us
Follow Us
+1
