CREATE TABLE table_name_2 (football VARCHAR2, soccer VARCHAR2, golf VARCHAR2)

Which foot ball team played soccer at wooster, and Gold in Ashland?
SELECT football FROM table_name_2 WHERE soccer = "wooster" AND golf = "ashland"
SELECT "football" FROM "table_name_2" WHERE "ashland" = "golf" AND "soccer" = "wooster"