What is the team id for Boston Red Stockings?
select distinct ( team_id ) from team where name = "Boston red Stockings"
Yes please.
select t1.player_id from salary as t1 join team as t2 on t1.team_id = t2.team_id_br where t2.name = 'Boston red Stockings'
Can you calculate the total salary paid by team Boston Red Stockings in 2010?
select sum ( t1.salary ) from salary as t1 join team as t2 on t1.team_id = t2.team_id_br where t2.name = 'Boston red Stockings' and t1.year = 2010