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

what was the shortest bridge mccullough designed ?
SELECT "bridge name" FROM table_204_507 ORDER BY "total length" LIMIT 1
SELECT "bridge name" FROM "table_204_507" ORDER BY "total length" FETCH FIRST 1 ROWS ONLY