CREATE TABLE table_name_27 (aug_2013 INT, jun_2011 VARCHAR, nov_2011 VARCHAR, jul_2012 VARCHAR)

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?
SELECT MAX(aug_2013) FROM table_name_27 WHERE nov_2011 < 968 AND jul_2012 = 31 AND jun_2011 > 30
SELECT MAX("aug_2013") FROM "table_name_27" WHERE "jul_2012" = 31 AND "jun_2011" > 30 AND "nov_2011" < 968