hevolx

-- Heaviest Hitters - This award goes to the team with the highest average weight of its batters on a given year
SELECT 
	ROUND(AVG(weight), 2) AS "Average Weight", 
	teams.name AS "Team Name",
	batting.yearid AS "Year"
FROM people
JOIN batting
	ON people.playerid = batting.playerid
JOIN teams
	ON  batting.team_id = teams.id