Advertisement
Guest User

Untitled

a guest
May 28th, 2015
269
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.60 KB | None | 0 0
  1. SELECT
  2. b.playerID,
  3. CONCAT(m.nameFirst, ' ', m.nameLast) AS NAME,
  4. AB,
  5. H,
  6. 2B,
  7. 3B,
  8. HR,
  9. R,
  10. RBI,
  11. SB,
  12. ROUND(BB / (AB + BB + HBP + COALESCE(SF, 0)) * 100, 2) AS BBPERC, #walks percentage
  13. ROUND(SO / (AB + BB + HBP + COALESCE(SF, 0)) * 100, 2) AS SOPERC, #strikeout percentage
  14. ROUND((H / AB), 3) AS AVG,
  15. (H + BB + HBP) / (AB + BB + HBP + SF) AS OBP,
  16. (H + 2B + 2 * 3B + 3 * HR) / AB AS SLG
  17. FROM
  18. Batting b,
  19. Master m
  20. WHERE
  21. b.playerID = m.playerID
  22. AND yearID = 1995
  23. AND teamID = 'ATL'
  24. GROUP BY b.playerID
  25. HAVING AB >= 300
  26. ORDER BY AB DESC;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement