CREATE TABLE table_6492 ("Tie no" CLOB, "Home team" CLOB, "Score" CLOB, "Away team" CLOB, "Attendance" CLOB)

Which Tie # has a Score of 3 0, and a Home team of bristol rovers?
SELECT "Tie no" FROM table_6492 WHERE "Score" = '3–0' AND "Home team" = 'bristol rovers'
SELECT "Tie no" FROM "table_6492" WHERE "Home team" = 'bristol rovers' AND "Score" = '3–0'