Skip to content

Instantly share code, notes, and snippets.

@friscojosh

friscojosh/Age adusted year over year

Created June 23, 2016 18:13
Show Gist options
  • Save friscojosh/933e64f4c9b26b0ad2112322a839a264 to your computer and use it in GitHub Desktop.
Save friscojosh/933e64f4c9b26b0ad2112322a839a264 to your computer and use it in GitHub Desktop.
Download ZIP
SQL for age adusted y/y queries
Raw
Age adusted year over year
SELECT *
FROM __pff_grades
WHERE pid IN (
SELECT __pff_grades.pid
FROM __pff_grades
INNER JOIN player
ON __pff_grades.pid = player.player
WHERE __pff_grades.season BETWEEN 2011 AND 2015 && pos1 ='RB' && __pff_grades.age = 22
)
&& __pff_grades.season BETWEEN 2011 AND 2015 && __pff_grades.age = 21
ORDER BY name ASC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment