CREATE TABLE table_204_888 (id NUMBER, "location" CLOB, "mile" NUMBER, "destinations" CLOB, "notes" CLOB)

how many miles is the us 522 south - berkeley springs , wv location ?
SELECT "mile" FROM table_204_888 WHERE "destinations" = 'us 522 south - berkeley springs, wv'
SELECT "mile" FROM "table_204_888" WHERE "destinations" = 'us 522 south - berkeley springs, wv'