CREATE TABLE debate_people (Debate_ID VARCHAR, Affirmative VARCHAR)
CREATE TABLE debate (Date VARCHAR, Venue VARCHAR, Debate_ID VARCHAR)
CREATE TABLE people (Name VARCHAR, People_ID VARCHAR)

Show the names of people, and dates and venues of debates they are on the affirmative side.
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
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"