CREATE TABLE table_name_3 (tie_no VARCHAR, home_team VARCHAR)

minehead has what tie number?
SELECT tie_no FROM table_name_3 WHERE home_team = "minehead"
SELECT "tie_no" FROM "table_name_3" WHERE "home_team" = "minehead"