CREATE TABLE table_name_59 (tie_no VARCHAR2, away_team VARCHAR2)

What is the tie no for the away team altrincham?
SELECT tie_no FROM table_name_59 WHERE away_team = "altrincham"
SELECT "tie_no" FROM "table_name_59" WHERE "altrincham" = "away_team"