CREATE TABLE table_202_12 (id NUMBER, "make" CLOB, "origin" CLOB, "in service" CLOB, "notes" CLOB)

how many makes origin from canada
SELECT COUNT("make") FROM table_202_12 WHERE "origin" = 'canada'
SELECT COUNT("make") FROM "table_202_12" WHERE "origin" = 'canada'