CREATE TABLE table_2849652_2 (sport VARCHAR2)

Where was the 2011-2012 soccer state tournament held?
SELECT 2011 AS _2012_state_tournament_location FROM table_2849652_2 WHERE sport = "Soccer"
SELECT 2011 AS "_2012_state_tournament_location" FROM "table_2849652_2" WHERE "Soccer" = "sport"