What is the team id for Boston Red Stockings?
SELECT distinct ( team_id )  FROM team where name  =  "Boston Red Stockings"
team id for Boston Red Stockings refers to a unique identification (team_id) for the team named 'Boston Red Stockings'; using DISTINCT to ensure unique team_id;