Table schema:
CREATE TABLE table_name_40 (home_team VARCHAR, tie_no VARCHAR)

Question: What home team has 8 ties?
SQL: SELECT home_team FROM table_name_40 WHERE tie_no = "8"