What is Soccer, when Cross Country is Lexington, and when School Year is 2011-12?
CREATE TABLE table_name_74 (soccer VARCHAR, cross_country VARCHAR, school_year VARCHAR)
SELECT soccer FROM table_name_74 WHERE cross_country = "lexington" AND school_year = "2011-12"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_74 (soccer VARCHAR, cross_country VARCHAR, school_year VARCHAR) Question: What is Soccer, when Cross Country is Lexington, and when School Year is 2011-12? [/INST] SELECT soccer FROM table_name_74 WHERE cross_country = "lexington" AND school_year = "2011-12" </s>