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 are the minimum and maximum vote percents of elections?
assistant
SELECT min(Vote_Percent) , max(Vote_Percent) FROM election
human
List the dates and vote percents of elections.
assistant
SELECT Date , Vote_Percent FROM election
human
How many distinct parties are there for representatives?
assistant
SELECT count(DISTINCT Party) FROM representative
human
List the votes of elections in descending order.
assistant
SELECT Votes FROM election ORDER BY Votes DESC
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 ;