How many deciles have an Authority of state and a Name of chertsey school?
CREATE TABLE table_name_21 (decile VARCHAR, authority VARCHAR, name VARCHAR)
SELECT COUNT(decile) FROM table_name_21 WHERE authority = "state" AND name = "chertsey school"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_21 (decile VARCHAR, authority VARCHAR, name VARCHAR) Question: How many deciles have an Authority of state and a Name of chertsey school? [/INST] SELECT COUNT(decile) FROM table_name_21 WHERE authority = "state" AND name = "chertsey school" </s>