Can you tell me the highest DCSF number that has the Name of field, and the Ofsted number larger than 117160?
CREATE TABLE table_name_52 (dcsf_number INTEGER, name VARCHAR, ofsted_number VARCHAR)
SELECT MAX(dcsf_number) FROM table_name_52 WHERE name = "field" AND ofsted_number > 117160
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_52 (dcsf_number INTEGER, name VARCHAR, ofsted_number VARCHAR) Question: Can you tell me the highest DCSF number that has the Name of field, and the Ofsted number larger than 117160? [/INST] SELECT MAX(dcsf_number) FROM table_name_52 WHERE name = "field" AND ofsted_number > 117160 </s>