CREATE TABLE table_204_507 (id NUMBER, "bridge name" CLOB, "location" CLOB, "year completed" NUMBER, "total length" CLOB, "carries" CLOB)

how many bridges are longer than 200 feet ?
SELECT COUNT("bridge name") FROM table_204_507 WHERE "total length" > 200
SELECT COUNT("bridge name") FROM "table_204_507" WHERE "total length" > 200