CREATE TABLE election (Representative_ID VARCHAR2)
CREATE TABLE representative (Lifespan VARCHAR2, Representative_ID VARCHAR2)

What are the lifespans of representatives in descending order of vote percent?
SELECT T2.Lifespan FROM election AS T1 JOIN representative AS T2 ON T1.Representative_ID = T2.Representative_ID ORDER BY Vote_Percent DESC
SELECT "T2"."Lifespan" FROM "election" "T1" JOIN "representative" "T2" ON "T1"."Representative_ID" = "T2"."Representative_ID" ORDER BY "Vote_Percent" DESC