What is the smallest roll with a Decile larger than 6, and a Name of broomfield school?
CREATE TABLE table_name_40 (roll INTEGER, decile VARCHAR, name VARCHAR)
SELECT MIN(roll) FROM table_name_40 WHERE decile > 6 AND name = "broomfield school"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_40 (roll INTEGER, decile VARCHAR, name VARCHAR) Question: What is the smallest roll with a Decile larger than 6, and a Name of broomfield school? [/INST] SELECT MIN(roll) FROM table_name_40 WHERE decile > 6 AND name = "broomfield school" </s>