CREATE TABLE table_name_40 (home_team VARCHAR2, tie_no VARCHAR2)

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