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 representatives from Republican party.
assistant
SELECT name FROM representative WHERE party = 'Republican';
human
What about their votes?
assistant
SELECT T2.name , T1.Votes FROM election AS T1 JOIN representative AS T2 ON T1.Representative_ID = T2.Representative_ID WHERE T2.Party = "Republican" ;