CREATE TABLE table_203_41 (id NUMBER, "name" CLOB, "variant name ( s ) " CLOB, "source" CLOB, "source coordinates" CLOB, "length" CLOB, "mouth" CLOB, "mouth coordinates" CLOB)

which is the only creek to be 1 mile in length ?
SELECT "name" FROM table_203_41 WHERE "length" = 1
SELECT "name" FROM "table_203_41" WHERE "length" = 1