CREATE TABLE table_name_27 (away_team VARCHAR, tie_no VARCHAR)

Which away team that had a tie of 7?
SELECT away_team FROM table_name_27 WHERE tie_no = "7"
SELECT "away_team" FROM "table_name_27" WHERE "7" = "tie_no"