What is the highest Aug 2013 with a Nov 2011 smaller than 968, and a Jul 2012 with 31, and a Jun 2011 larger than 30?
CREATE TABLE table_name_27 (aug_2013 INTEGER, jun_2011 VARCHAR, nov_2011 VARCHAR, jul_2012 VARCHAR)
SELECT MAX(aug_2013) FROM table_name_27 WHERE nov_2011 < 968 AND jul_2012 = 31 AND jun_2011 > 30
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_27 (aug_2013 INTEGER, jun_2011 VARCHAR, nov_2011 VARCHAR, jul_2012 VARCHAR) Question: What is the highest Aug 2013 with a Nov 2011 smaller than 968, and a Jul 2012 with 31, and a Jun 2011 larger than 30? [/INST] SELECT MAX(aug_2013) FROM table_name_27 WHERE nov_2011 < 968 AND jul_2012 = 31 AND jun_2011 > 30 </s>