How many candidates are there?
CREATE TABLE people (
    people_id number,
    sex text,
    name text,
    date_of_birth text,
    height number,
    weight number
)

CREATE TABLE candidate (
    candidate_id number,
    people_id number,
    poll_source text,
    date text,
    support_rate number,
    consider_rate number,
    oppose_rate number,
    unsure_rate number
)
SELECT COUNT(*) FROM candidate
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 are there? ### Input: CREATE TABLE people (
    people_id number,
    sex text,
    name text,
    date_of_birth text,
    height number,
    weight number
)

CREATE TABLE candidate (
    candidate_id number,
    people_id number,
    poll_source text,
    date text,
    support_rate number,
    consider_rate number,
    oppose_rate number,
    unsure_rate number
) ### Response: SELECT COUNT(*) FROM candidate