CREATE TABLE member (Name VARCHAR2, Member_ID VARCHAR2)
CREATE TABLE round (Member_ID VARCHAR2)

Show the names of members in ascending order of their rank in rounds.
SELECT T1.Name FROM member AS T1 JOIN round AS T2 ON T1.Member_ID = T2.Member_ID ORDER BY Rank_in_Round
SELECT "T1"."Name" FROM "member" "T1" JOIN "round" "T2" ON "T1"."Member_ID" = "T2"."Member_ID" ORDER BY "Rank_in_Round"