CREATE TABLE table_41720 ("Tie no" CLOB, "Home team" CLOB, "Score" CLOB, "Away team" CLOB, "Date" CLOB, "Attendance" CLOB)

How many ties does Walsall have?
SELECT "Tie no" FROM table_41720 WHERE "Away team" = 'walsall'
SELECT "Tie no" FROM "table_41720" WHERE "Away team" = 'walsall'