CREATE TABLE table_203_594 (id NUMBER, "canal" CLOB, "length  ( miles ) " NUMBER, "locks" NUMBER, "max length  ( ft ) " NUMBER, "width  ( ft ) " NUMBER, "year opened" NUMBER, "year abandoned" NUMBER, "year restored" NUMBER)

which was the last canal opened in scotland ?
SELECT "canal" FROM table_203_594 WHERE "year opened" = (SELECT MAX("year opened") FROM table_203_594)
SELECT "canal" FROM "table_203_594" WHERE "year opened" = (SELECT MAX("year opened") FROM "table_203_594")