CREATE TABLE table_42474 ("Tie no" CLOB, "Home team" CLOB, "Score" CLOB, "Away team" CLOB, "Date" CLOB, "Attendance" FLOAT)

What home team has 8 ties?
SELECT "Home team" FROM table_42474 WHERE "Tie no" = '8'
SELECT "Home team" FROM "table_42474" WHERE "Tie no" = '8'