"500" home run hitters: team totals.

For the 29 who hit at least 493 career home runs, this post adds up the number hit for their team(s). The previous post in this series is pertinent:

"500" home runs by hitter by team. Wednesday, May 13, 2020

27 of the current 30 teams had at least one home run hit by one of these 29 top home run hitters. Teams absent: Rockies, D'Backs, Nationals/Expos.

Query1

theTeam	HR	Hitters
Yankees	2259	6
Giants	2212	4
Red Sox	1549	5
Braves	1426	5
Cubs	1127	5
Athletics	978	4
Orioles/Browns	789	6
Cardinals	665	2
Phillies	656	3
Twins/Senators	654	3
Indians	637	4
White Sox	614	5
Mariners	606	2
Reds	534	2
Rangers	499	3
Angels	387	4
Dodgers	270	5
Padres	179	3
Pirates	176	1
Blue Jays	154	2
Marlins	122	1
Rays	99	1
Mets	67	3
Tigers	53	2
Brewers	43	2
Royals	14	1
Astros	10	1

The top five teams had at least 1,000 home runs hit by some of the 29. Here are those players:

Query2

theTeam	Fname	Lname	HRteam	Year1	YearL	HR
Yankees	Babe	Ruth	659	1920	1934	714
Yankees	Mickey	Mantle	536	1951	1968	536
Yankees	Lou	Gehrig	493	1923	1938	493
Yankees	Alex	Rodriguez	351	2004	2016	696
Yankees	Reggie	Jackson	144	1977	1981	563
Yankees	Gary	Sheffield	76	2004	2006	509

Query2

theTeam	Fname	Lname	HRteam	Year1	YearL	HR
Giants	Willie	Mays	646	1951	1971	660
Giants	Barry	Bonds	586	1993	2007	762
Giants	Mel	Ott	511	1927	1946	511
Giants	Willie	McCovey	469	1959	1980	521

In 1972 before being traded to the Mets, Mays had zero HR with the Giants in 49 AB.

Query2

theTeam	Fname	Lname	HRteam	Year1	YearL	HR
Red Sox	Ted	Williams	521	1939	1960	521
Red Sox	David	Ortiz	483	2003	2016	541
Red Sox	Manny	Ramirez	274	2001	2008	555
Red Sox	Jimmie	Foxx	222	1936	1942	534
Red Sox	Babe	Ruth	49	1915	1919	714

Query2

theTeam	Fname	Lname	HRteam	Year1	YearL	HR
Braves	Hank	Aaron	733	1954	1974	755
Braves	Eddie	Mathews	493	1952	1966	512
Braves	Fred	McGriff	130	1993	1997	493
Braves	Gary	Sheffield	64	2002	2003	509
Braves	Babe	Ruth	6	1935	1935	714

Query2

theTeam	Fname	Lname	HRteam	Year1	YearL	HR
Cubs	Sammy	Sosa	545	1992	2004	609
Cubs	Ernie	Banks	512	1953	1971	512
Cubs	Fred	McGriff	42	2001	2002	493
Cubs	Rafael	Palmeiro	25	1986	1988	569
Cubs	Jimmie	Foxx	3	1942	1942	534

Babe Ruth homered for three of the top five teams: Yankees, Red Sox and Braves.

Among the hitters on those top five teams, only these hit all their home runs for one and only one team:
Mantle: Yankees 536
Williams: Red Sox 521
Banks: Cubs 512
Ott: Giants 511
Gehrig: Yankees 493