What are the names of representatives in descending order of votes please?
select t2.name from election as t1 join representative as t2 on t1.representative_id = t2.representative_id order by votes desc
What are their parties?
select t2.name, t2.party from election as t1 join representative as t2 on t1.representative_id = t2.representative_id order by votes desc
What states are they from, please?
select t2.name, t2.state from election as t1 join representative as t2 on t1.representative_id = t2.representative_id order by votes desc
What are their vote percents?
select t2.name, t1.vote_percent from election as t1 join representative as t2 on t1.representative_id = t2.representative_id order by votes desc
What about their dates?
select t2.name, t1.date from election as t1 join representative as t2 on t1.representative_id = t2.representative_id order by votes desc