CREATE TABLE table_name_39 (tie_no VARCHAR2, score VARCHAR2, home_team VARCHAR2)

Which Tie # has a Score of 3 0, and a Home team of bristol rovers?
SELECT tie_no FROM table_name_39 WHERE score = "3–0" AND home_team = "bristol rovers"
SELECT "tie_no" FROM "table_name_39" WHERE "3–0" = "score" AND "bristol rovers" = "home_team"