CREATE TABLE table_24354 ("Type of Record" CLOB, "Attendance" FLOAT, "Date/Year" CLOB, "Stadium" CLOB, "Result/Games" CLOB)

how many records had result/games: 10 games (29,606 avg.)
SELECT COUNT("Type of Record") FROM table_24354 WHERE "Result/Games" = '10 games (29,606 avg.)'
SELECT COUNT("Type of Record") FROM "table_24354" WHERE "Result/Games" = '10 games (29,606 avg.)'