What's the total enrollment in 57 Noble having a # and AA as the IHSAA Class?
CREATE TABLE table_name_95 (enrollment VARCHAR, _number___county VARCHAR, ihsaa_class VARCHAR)
SELECT COUNT(enrollment) FROM table_name_95 WHERE _number___county = "57 noble" AND ihsaa_class = "aa"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_95 (enrollment VARCHAR, _number___county VARCHAR, ihsaa_class VARCHAR) Question: What's the total enrollment in 57 Noble having a # and AA as the IHSAA Class? [/INST] SELECT COUNT(enrollment) FROM table_name_95 WHERE _number___county = "57 noble" AND ihsaa_class = "aa" </s>