CREATE TABLE team (team_id_br VARCHAR2, name VARCHAR2)
CREATE TABLE salary (salary NUMBER, team_id VARCHAR2, year VARCHAR2)

What is 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
SELECT SUM("T1"."salary") FROM "salary" "T1" JOIN "team" "T2" ON "T1"."team_id" = "T2"."team_id_br" AND "T2"."name" = 'Boston Red Stockings' WHERE "T1"."year" = 2010