CREATE TABLE table_204_786 (id NUMBER, "riding" CLOB, "candidate" CLOB, "gender" CLOB, "residence" CLOB, "occupation" CLOB, "votes" NUMBER, "%" NUMBER, "rank" CLOB, "biographical notes" CLOB)

how many candidates were from halifax ?
SELECT COUNT("candidate") FROM table_204_786 WHERE "residence" = 'halifax'
SELECT COUNT("candidate") FROM "table_204_786" WHERE "residence" = 'halifax'