Recently, at MVN's Statistically Speaking (Stat Speak), Colin Wyers, of the Marcels I posted last week, has a series running entitled, "Building a sabermetricans work bench." It basically walks you though how to set up a MySQL structured database full of baseball stats, and it has been a godsend for me.
Having played around with some of his example queries, I wanted to see who has been the best pitcher in the last decade, and being fairly uninitiated in culling out deeper data than the basics, I used ERA, and a minimum average of 150 IP/year:
I thought two things when I saw the result:
- I love Roy Oswalt.
- How incredible would a 2005 rotation of: Roy Oswalt, Johan Santana (had he not been traded lost in the Rule 5 draft), Roger Clemens, and Andy Pettitte.