CREATE TABLE table_name_47 (attendance INT, tie_no VARCHAR)

How many attended tie number 1?
SELECT SUM(attendance) FROM table_name_47 WHERE tie_no = "1"
SELECT SUM("attendance") FROM "table_name_47" WHERE "1" = "tie_no"