CREATE TABLE people (people_id DECIMAL, district TEXT, name TEXT, party TEXT, age DECIMAL)
CREATE TABLE debate (debate_id DECIMAL, date TEXT, venue TEXT, num_of_audience DECIMAL)
CREATE TABLE debate_people (debate_id DECIMAL, affirmative DECIMAL, negative DECIMAL, if_affirmative_win others)

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"