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

how many bridges are 400 feet long at most ?
SELECT COUNT("bridge name") FROM table_204_507 WHERE "total length" <= 400
SELECT COUNT("bridge name") FROM "table_204_507" WHERE "total length" <= 400