Task: Text to Code
Input (English): Step 1: For each row in people table, find the corresponding rows in candidate table.
Step 2: find Sex, Consider_rate, Oppose_rate of the results of step 1 ordered ascending by Unsure_rate
Output (English): SELECT T2.Sex , T1.Consider_rate , T1.Oppose_rate FROM candidate AS T1 JOIN people AS T2 ON T1.People_ID = T2.People_ID ORDER BY T1.Unsure_rate Asc