CREATE TABLE table_204_325 (id NUMBER, "class" CLOB, "name" CLOB, "company" CLOB, "residence" CLOB, "term expires dec 31" NUMBER, "notes" CLOB)

how many residence is there ?
SELECT COUNT("residence") FROM table_204_325
SELECT COUNT("residence") FROM "table_204_325"