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 different parties of representative? Show the party name and the number of representatives in each party.
assistant
SELECT Party , COUNT(*) FROM representative GROUP BY Party
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 are the names and parties of representatives?
assistant
SELECT Name , Party FROM representative
human
What parties have at least three representatives?
assistant
SELECT Party FROM representative GROUP BY Party HAVING COUNT(*) >= 3
human
How many distinct parties are there for representatives?
assistant
SELECT COUNT( DISTINCT Party ) FROM representative ;