Table: bromet_primary_school
Columns: name
faith
type
intake
dcsf_number
ofsted_number

Question: Can you tell me the highest DCSF number that has the Name of field, and the Ofsted number larger than 117160?
SQL: SELECT MAX("dcsf_number") FROM bromet_primary_school WHERE "name" = 'field' AND "ofsted_number" > 117160

Question: Can you tell me the sum of Intake that has the Faith of rc, and the DCSF number larger than 2428?
SQL: SELECT SUM("intake") FROM bromet_primary_school WHERE "faith" = 'rc' AND "dcsf_number" > 2428

Question: Can you tell me the Name that has the DCSF number of 2117?
SQL: SELECT "name" FROM bromet_primary_school WHERE "dcsf_number" = 2117

Question: Can you tell me the highest Ofsted number that has the Type of infants, and the Intake larger than 60?
SQL: SELECT MAX("ofsted_number") FROM bromet_primary_school WHERE "type" = 'infants' AND "intake" > 60