Name the average total medals with ensemble of goshen hs
CREATE TABLE table_name_2 (
    total_medals INTEGER,
    ensemble VARCHAR
)
SELECT AVG(total_medals) FROM table_name_2 WHERE ensemble = "goshen hs"
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: Name the average total medals with ensemble of goshen hs ### Input: CREATE TABLE table_name_2 (
    total_medals INTEGER,
    ensemble VARCHAR
) ### Response: SELECT AVG(total_medals) FROM table_name_2 WHERE ensemble = "goshen hs"