CREATE TABLE people (Name VARCHAR(255), People_ID VARCHAR(255)); CREATE TABLE debate (Date VARCHAR(255), Venue VARCHAR(255), Debate_ID VARCHAR(255)); CREATE TABLE debate_people (Debate_ID VARCHAR(255), Affirmative VARCHAR(255))
Show the names of people, and dates and venues of debates they are on the affirmative side.
    
SQL: SELECT T3.Name, T2.Date, T2.Venue FROM debate_people AS T1 JOIN debate AS T2 ON T1.Debate_ID = T2.Debate_ID JOIN people AS T3 ON T1.Affirmative = T3.People_ID