CREATE TABLE people (people_id NUMBER, sex CLOB, name CLOB, date_of_birth CLOB, height NUMBER, weight NUMBER)
CREATE TABLE candidate (candidate_id NUMBER, people_id NUMBER, poll_source CLOB, date CLOB, support_rate NUMBER, consider_rate NUMBER, oppose_rate NUMBER, unsure_rate NUMBER)

What is the name and sex of the candidate with the highest support rate?
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
SELECT "t1"."name", "t1"."sex" FROM "people" "t1" JOIN "candidate" "t2" ON "t1"."people_id" = "t2"."people_id" ORDER BY "t2"."support_rate" DESC FETCH FIRST 1 ROWS ONLY