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 minimum vote percent of elections?
assistant
SELECT MIN( Vote_Percent ) FROM election;
human
what is the maximum vote percent of elections?
assistant
SELECT MAX( Vote_Percent ) FROM election;
human
Which election had the most votes?
assistant
SELECT election_id FROM election WHERE votes = ( SELECT MAX( votes ) FROM election );
human
Which election had the least votes?
assistant
SELECT election_id FROM election WHERE votes = ( SELECT MIN( votes ) FROM election ) ;