CREATE TABLE table_name_38 (away_team VARCHAR, tie_no VARCHAR)

Which Away team has a Tie no of 4?
SELECT away_team FROM table_name_38 WHERE tie_no = "4"
SELECT "away_team" FROM "table_name_38" WHERE "4" = "tie_no"