CREATE TABLE table_204_423 (id NUMBER, "name" CLOB, "location" CLOB, "city" CLOB, "listing date" CLOB)

how many historic sites were listed in 1988 ?
SELECT COUNT("name") FROM table_204_423 WHERE "listing date" = 1988
SELECT COUNT("name") FROM "table_204_423" WHERE "listing date" = 1988