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
Show me the name of the states of representative.
assistant
SELECT State FROM representative;
human
What about their number of representatives?
assistant
SELECT State , COUNT( * ) FROM representative GROUP BY State;
human
Show me the states that have at least of them.
assistant
SELECT State FROM representative GROUP BY State HAVING COUNT( * ) >= 2 ;