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

number of current vacancies
SELECT COUNT(*) FROM table_204_325 WHERE "name" = 'vacancy'
SELECT COUNT(*) FROM "table_204_325" WHERE "name" = 'vacancy'