Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- b.playerID,
- CONCAT(m.nameFirst, ' ', m.nameLast) AS NAME,
- AB,
- H,
- 2B,
- 3B,
- HR,
- R,
- RBI,
- SB,
- ROUND(BB / (AB + BB + HBP + COALESCE(SF, 0)) * 100, 2) AS BBPERC, #walks percentage
- ROUND(SO / (AB + BB + HBP + COALESCE(SF, 0)) * 100, 2) AS SOPERC, #strikeout percentage
- ROUND((H / AB), 3) AS AVG,
- (H + BB + HBP) / (AB + BB + HBP + SF) AS OBP,
- (H + 2B + 2 * 3B + 3 * HR) / AB AS SLG
- FROM
- Batting b,
- Master m
- WHERE
- b.playerID = m.playerID
- AND yearID = 1995
- AND teamID = 'ATL'
- GROUP BY b.playerID
- HAVING AB >= 300
- ORDER BY AB DESC;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement