how many candidates were from halifax ?
CREATE TABLE table_204_786 (
    id number,
    "riding" text,
    "candidate" text,
    "gender" text,
    "residence" text,
    "occupation" text,
    "votes" number,
    "%" number,
    "rank" text,
    "biographical notes" text
)
SELECT COUNT("candidate") FROM table_204_786 WHERE "residence" = 'halifax'
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: how many candidates were from halifax ? ### Input: CREATE TABLE table_204_786 (
    id number,
    "riding" text,
    "candidate" text,
    "gender" text,
    "residence" text,
    "occupation" text,
    "votes" number,
    "%" number,
    "rank" text,
    "biographical notes" text
) ### Response: SELECT COUNT("candidate") FROM table_204_786 WHERE "residence" = 'halifax'