CREATE TABLE table_204_608 (id NUMBER, "name" CLOB, "elected party" CLOB, "constituency" CLOB, "elected date" CLOB, "military service" CLOB)

how many people served in the canadian army ?
SELECT COUNT("name") FROM table_204_608 WHERE "military service" = 'canadian army'
SELECT COUNT("name") FROM "table_204_608" WHERE "military service" = 'canadian army'