Task: Text to Code
Input (English): Step 1: For each row in debate_people table, find corresponding rows in people table and in debate table.
Step 2: find Name of the results of step 1 whose Num_of_Audience greater than 342.
Step 3: find Name of the results of step 1 whose Num_of_Audience greater than 200.
Step 4: show the rows that are in both the results of step 2 and the results of step 3
Output (English): SELECT T1.Name FROM people AS T1 JOIN debate AS T2 JOIN debate_people AS T3 ON T1.People_ID = T3.Affirmative AND T3.Debate_ID = T2.Debate_ID WHERE T2.Num_of_Audience > 342 INTERSECT SELECT T1.Name FROM people AS T1 JOIN debate AS T2 JOIN debate_people AS T3 ON T1.People_ID = T3.Affirmative AND T3.Debate_ID = T2.Debate_ID WHERE T2.Num_of_Audience > 200