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

What is Away Team, when Tie No is 4?
SELECT "Away team" FROM table_41004 WHERE "Tie no" = '4'
SELECT "Away team" FROM "table_41004" WHERE "Tie no" = '4'