CREATE TABLE table_203_760 (id NUMBER, "name" CLOB, "state" CLOB, "status" CLOB, "title" CLOB, "appointment" CLOB, "credentials\ presented" CLOB, "termination\ of mission" CLOB, "notes" CLOB)

how many chiefs are from new york ?
SELECT COUNT("name") FROM table_203_760 WHERE "state" = 'new york'
SELECT COUNT("name") FROM "table_203_760" WHERE "state" = 'new york'