crinan canal is only half of what other canal
CREATE TABLE table_203_594 (
    id number,
    "canal" text,
    "length (miles)" number,
    "locks" number,
    "max length (ft)" number,
    "width (ft)" number,
    "year opened" number,
    "year abandoned" number,
    "year restored" number
)
SELECT "canal" FROM table_203_594 WHERE "length (miles)" = (SELECT "length (miles)" FROM table_203_594 WHERE "canal" = 'crinan canal') / 0.5
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: crinan canal is only half of what other canal ### Input: CREATE TABLE table_203_594 (
    id number,
    "canal" text,
    "length (miles)" number,
    "locks" number,
    "max length (ft)" number,
    "width (ft)" number,
    "year opened" number,
    "year abandoned" number,
    "year restored" number
) ### Response: SELECT "canal" FROM table_203_594 WHERE "length (miles)" = (SELECT "length (miles)" FROM table_203_594 WHERE "canal" = 'crinan canal') / 0.5