CREATE TABLE table_203_40 (id NUMBER, "p.s. #" NUMBER, "school name" CLOB, "neighborhood" CLOB, "low grade" CLOB, "high grade" NUMBER, "year closed" CLOB, "building status" CLOB)

what is the total number of schools that are now vacant ?
SELECT COUNT("school name") FROM table_203_40 WHERE "building status" = 'vacant'
SELECT COUNT("school name") FROM "table_203_40" WHERE "building status" = 'vacant'