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 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'
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 elections are there?
assistant
SELECT count(*) FROM election
human
List the dates and vote percents of elections.
assistant
SELECT Date , Vote_Percent FROM election
human
What are the minimum and maximum vote percents of elections?
assistant
SELECT MIN( Vote_Percent ) , MAX( Vote_Percent ) FROM election ;