CREATE TABLE table_name_47 (attendance VARCHAR, home_team VARCHAR)

How many people attended the game of a.f.c. totton?
SELECT attendance FROM table_name_47 WHERE home_team = "a.f.c. totton"
SELECT "attendance" FROM "table_name_47" WHERE "a.f.c. totton" = "home_team"