human
Schema:
people (People_ID, District, Name, Party, Age)
debate (Debate_ID, Date, Venue, Num_of_Audience)
debate_people (Debate_ID, Affirmative, Negative, If_Affirmative_Win)
Please answer with SQL.
assistant
Sure, I understand.
human
How many people have ever been on the negative side of debates?
assistant
SELECT COUNT( DISTINCT T2.People_ID ) FROM debate_people AS T1 JOIN people AS T2 ON T1.Negative = T2.People_ID;
human
How many times have they been on the negative side of debates?
assistant
SELECT T2.Name , COUNT( * ) FROM debate_people AS T1 JOIN people AS T2 ON T1.Negative = T2.People_ID GROUP BY T2.Name ;