Find the name and gender of the candidate who got the highest support rate.
CREATE TABLE people (
    name VARCHAR,
    sex VARCHAR,
    people_id VARCHAR
)

CREATE TABLE candidate (
    people_id VARCHAR,
    support_rate VARCHAR
)
SELECT t1.name, t1.sex FROM people AS t1 JOIN candidate AS t2 ON t1.people_id = t2.people_id ORDER BY t2.support_rate DESC LIMIT 1
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: Find the name and gender of the candidate who got the highest support rate. ### Input: CREATE TABLE people (
    name VARCHAR,
    sex VARCHAR,
    people_id VARCHAR
)

CREATE TABLE candidate (
    people_id VARCHAR,
    support_rate VARCHAR
) ### Response: SELECT t1.name, t1.sex FROM people AS t1 JOIN candidate AS t2 ON t1.people_id = t2.people_id ORDER BY t2.support_rate DESC LIMIT 1