Show me the name of representatives from Republican party.
select name from representative where party = "Republican"
What about their votes?
select t2.name, t1.votes from election as t1 join representative as t2 on t1.representative_id = t2.representative_id where t2.party = "Republican"
Show me the average of them.
select avg(t1.votes) from election as t1 join representative as t2 on t1.representative_id = t2.representative_id where t2.party = "Republican"