CREATE TABLE table_name_97 (tie_no VARCHAR2, home_team VARCHAR2)

Which Tie is from birmingham city?
SELECT tie_no FROM table_name_97 WHERE home_team = "birmingham city"
SELECT "tie_no" FROM "table_name_97" WHERE "birmingham city" = "home_team"