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
Only show me the name of those with more than 10000 votes.
select t2.name from election as t1 join representative as t2 on t1.representative_id = t2.representative_id where votes > 10000