which bridge is longer - old youngs bay bridge or oregon city bridge ?
CREATE TABLE table_204_507 (
    id number,
    "bridge name" text,
    "location" text,
    "year completed" number,
    "total length" text,
    "carries" text
)
SELECT "bridge name" FROM table_204_507 WHERE "bridge name" IN ('old youngs bay bridge', 'oregon city bridge') ORDER BY "total length" DESC LIMIT 1
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: which bridge is longer - old youngs bay bridge or oregon city bridge ? ### Input: CREATE TABLE table_204_507 (
    id number,
    "bridge name" text,
    "location" text,
    "year completed" number,
    "total length" text,
    "carries" text
) ### Response: SELECT "bridge name" FROM table_204_507 WHERE "bridge name" IN ('old youngs bay bridge', 'oregon city bridge') ORDER BY "total length" DESC LIMIT 1