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

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