Hey all

Let's say I want to look at the New York Yankees and aggregate their hitters' stats for the entire 2011 season for the following stuff:

Plate appearances (I can't find the shortname_tx for this...)
K
SB
BB (NIBB + IBB)
1B
2B
3B
HR

How could I code this up in a query (I'm using SQLyog)?

I've been reading through baseball hacks but due to my non-existent programming skills, am really struggling with this. I would appreciate any help or advice!