human
Schema:
election (Election_ID, Representative_ID, Date, Votes, Vote_Percent, Seats, Place)
representative (Representative_ID, Name, State, Party, Lifespan)
Please answer with SQL.
assistant
Sure, I understand.
human
What is the party of the representative that has the smallest number of votes.
assistant
SELECT T2.Party FROM election AS T1 JOIN representative AS T2 ON T1.Representative_ID = T2.Representative_ID ORDER BY votes ASC LIMIT 1
human
What are the names of representatives with more than 10000 votes in election?
assistant
SELECT T2.Name FROM election AS T1 JOIN representative AS T2 ON T1.Representative_ID = T2.Representative_ID WHERE Votes > 10000
human
How many distinct parties are there for representatives?
assistant
SELECT count(DISTINCT Party) FROM representative
human
What are the names of representatives whose party is not 'Republican'?
assistant
SELECT Name FROM Representative WHERE Party != 'Republican'
human
What is the party that has the largest number of representatives?
assistant
SELECT Party , COUNT(*) FROM representative GROUP BY Party ORDER BY COUNT(*) DESC LIMIT 1
human
What is the average number of votes of representatives from party 'Republican'?
assistant
SELECT avg ( T1.Votes ) FROM election AS T1 JOIN representative AS T2 ON T1.Representative_ID = T2.Representative_ID WHERE T2.Party = "Republican" ;