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)

how many canals are there in scotland ?
SELECT COUNT("canal") FROM table_203_594
SELECT COUNT("canal") FROM "table_203_594"