Table 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?
SQL: SELECT stadium FROM table_24949975_1 WHERE home_team = "Shamrock Rovers" AND result = "3–0"