Who was the male rep. when Caroline Rhoads was the artistic director?
CREATE TABLE table_22410780_1 (male_rep VARCHAR, artistic_director VARCHAR)
SELECT male_rep FROM table_22410780_1 WHERE artistic_director = "Caroline Rhoads"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_22410780_1 (male_rep VARCHAR, artistic_director VARCHAR) Question: Who was the male rep. when Caroline Rhoads was the artistic director? [/INST] SELECT male_rep FROM table_22410780_1 WHERE artistic_director = "Caroline Rhoads" </s>