Which Tie # has a Score of 3–0, and a Home team of bristol rovers?
CREATE TABLE table_name_39 (tie_no VARCHAR, score VARCHAR, home_team VARCHAR)
SELECT tie_no FROM table_name_39 WHERE score = "3–0" AND home_team = "bristol rovers"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_39 (tie_no VARCHAR, score VARCHAR, home_team VARCHAR) Question: Which Tie # has a Score of 3–0, and a Home team of bristol rovers? [/INST] SELECT tie_no FROM table_name_39 WHERE score = "3–0" AND home_team = "bristol rovers" </s>