CREATE TABLE table_name_52 (tie_no VARCHAR2, home_team VARCHAR2)

WHAT IS NO TIE FROM brighton & hove albion?
SELECT tie_no FROM table_name_52 WHERE home_team = "brighton & hove albion"
SELECT "tie_no" FROM "table_name_52" WHERE "brighton & hove albion" = "home_team"