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

Who was the away team for tie number 9?
SELECT "Away team" FROM table_42508 WHERE "Tie no" = '9'
SELECT "Away team" FROM "table_42508" WHERE "Tie no" = '9'