Show me the name of all the representatives.
select name from representative
What about their votes in their elections?
select t2.name,t1.votes from election as t1 join representative as t2 on t1.representative_id = t2.representative_id
Show me their names in descending order of votes.
select t2.name from election as t1 join representative as t2 on t1.representative_id = t2.representative_id order by votes desc