CREATE TABLE table_204_452 (id NUMBER, "number" CLOB, "south or west terminus" CLOB, "north or east terminus" CLOB, "length  ( mi ) " NUMBER, "length  ( km ) " NUMBER, "formed" CLOB, "deleted" CLOB, "notes" CLOB)

what is the number of miles that number sr-3 has ?
SELECT "length (mi)" FROM table_204_452 WHERE "number" = 'sr-3'
SELECT "length (mi)" FROM "table_204_452" WHERE "number" = 'sr-3'