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

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