CREATE TABLE table_204_757 (id NUMBER, "state" CLOB, "interview" NUMBER, "swimsuit" NUMBER, "evening gown" NUMBER, "average" NUMBER)

how many state has an average under 8.5 ?
SELECT COUNT("state") FROM table_204_757 WHERE "average" < 8.5
SELECT COUNT("state") FROM "table_204_757" WHERE "average" < 8.5