I found where I left off, skipped 2011 since the winner came out of a synthetic track race. Not sure how to handle those. I'll work on it next week.
Then I did 2010. Top three were Ice Box, Dublin, Super Saver.
For some reason (maybe pre synthetics?), I then went to the beginning of my data, 2004:
Top 3: The Cliff's Edge, Lion Heart, Smarty Jones
The last one I did was 2005: Afleet Alex, Bellamy Road, Greeley's Galaxy
I'll finish the rest this week and post. The query is all set up but takes a bit to run it for each year and pair up with the horses that actually ran in the Derby.
I guess I'll just treat synth race like the others and see how it works out.
|