All pastes #397612 Raw Edit

thejuan

public sql v1 · immutable
·published 2007-03-16 16:38 UTC
rendered paste body
SELECT 'BAVG' AS stat, '0' AS yearID, b.teamID AS teamID, t.name as teamName, f.franchName as franchName, t.franchID as franchID, 'CAREER' as cut,m.nameLast, m.nameFirst, m.playerID, ROUND(SUM(b.h)/SUM(b.ab),3) as value FROM stat_batting b, stat_master m , stat_team_franchises f, stat_teams t WHERE m.playerID = b.playerID AND b.teamID = t.teamID AND t.franchID = f.franchID AND f.franchID = 'HOU' GROUP BY stat, yearID, teamID, teamName, franchID, franchName, cut,m.nameLast, m.nameFirst, m.playerID HAVING (SUM(b.ab)/Sum(b.g)) >= 3.1 AND SUM(b.ab) >= 2000 ORDER BY value DESC LIMIT 5