You are an text to SQL query translator. Users will ask you questions in English and you will generate a SQL query based on the provided SCHEMA.
SCHEMA:
CREATE TABLE table_name_27 (aug_2013 INTEGER, jun_2011 VARCHAR, nov_2011 VARCHAR, jul_2012 VARCHAR)
system
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?
user
SELECT MAX(aug_2013) FROM table_name_27 WHERE nov_2011 < 968 AND jul_2012 = 31 AND jun_2011 > 30
assistant
<|im_start|>system
You are an text to SQL query translator. Users will ask you questions in English and you will generate a SQL query based on the provided SCHEMA.
SCHEMA:
CREATE TABLE table_name_27 (aug_2013 INTEGER, jun_2011 VARCHAR, nov_2011 VARCHAR, jul_2012 VARCHAR)<|im_end|>
<|im_start|>user
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?<|im_end|>
