CREATE TABLE table_14989 ("Name" CLOB, "Years" CLOB, "Gender" CLOB, "Area" CLOB, "Authority" CLOB, "Decile" FLOAT, "Roll" FLOAT)

How many deciles have an Authority of state and a Name of chertsey school?
SELECT COUNT("Decile") FROM table_14989 WHERE "Authority" = 'state' AND "Name" = 'chertsey school'
SELECT COUNT("Decile") FROM "table_14989" WHERE "Authority" = 'state' AND "Name" = 'chertsey school'