What was the stadium for the home team of shamrock rovers and result of 3–0?
CREATE TABLE table_24949975_1 (stadium VARCHAR, home_team VARCHAR, result VARCHAR)
SELECT stadium FROM table_24949975_1 WHERE home_team = "Shamrock Rovers" AND result = "3–0"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_24949975_1 (stadium VARCHAR, home_team VARCHAR, result VARCHAR) Question: What was the stadium for the home team of shamrock rovers and result of 3–0? [/INST] SELECT stadium FROM table_24949975_1 WHERE home_team = "Shamrock Rovers" AND result = "3–0" </s>