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

what is the total number of locations in the city of algonac ?
SELECT COUNT("location") FROM table_204_558 WHERE "city" = 'algonac'
SELECT COUNT("location") FROM "table_204_558" WHERE "city" = 'algonac'