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 name of parties of representatives?
assistant
SELECT DISTINCT Party FROM representative;
human
Show me the number of representatives in each party.
assistant
SELECT Party , COUNT( * ) FROM representative GROUP BY Party;
human
Give me the party that has more.
assistant
SELECT Party , COUNT( * ) FROM representative GROUP BY Party ORDER BY COUNT( * ) DESC LIMIT 1 ;