Show the names of people that won the debate on the nagative side.
select t2.name from debate_people as t1 join people as t2 on t1.negative = t2.people_id where if_affirmative_win = "F"
Please list the names of people who have been on the negative side.
select t2.name from debate_people as t1 join people as t2 on t1.negative = t2.people_id
Please also show the dates and venues of debates
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.negative = t3.people_id
Could you please order the results in ascending alphabetical order of name?
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.negative = t3.people_id order by t3.name asc