CREATE TABLE table_204_799 (id NUMBER, "name" CLOB, "built" CLOB, "listed" CLOB, "location" CLOB, "county" CLOB, "type" CLOB)

how many total bridges are in copiah county ?
SELECT COUNT(DISTINCT "name") FROM table_204_799 WHERE "county" = 'copiah'
SELECT COUNT(DISTINCT "name") FROM "table_204_799" WHERE "county" = 'copiah'