CREATE TABLE team (team_id_br VARCHAR, name VARCHAR)
CREATE TABLE home_game (games INT, team_id VARCHAR, year VARCHAR)

How many home games did the team Boston Red Stockings play from 1990 to 2000 in total?
SELECT SUM(T1.games) FROM home_game AS T1 JOIN team AS T2 ON T1.team_id = T2.team_id_br WHERE T2.name = 'Boston Red Stockings' AND T1.year BETWEEN 1990 AND 2000
SELECT SUM("T1"."games") FROM "home_game" AS "T1" JOIN "team" AS "T2" ON "T1"."team_id" = "T2"."team_id_br" AND "T2"."name" = 'Boston Red Stockings' WHERE "T1"."year" <= 2000 AND "T1"."year" >= 1990