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

how many sites are in coldwater ?
SELECT COUNT("name") FROM table_204_423 WHERE "city" = 'coldwater'
SELECT COUNT("name") FROM "table_204_423" WHERE "city" = 'coldwater'