list the name of the members in the 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 ASC
list the name of the members in the order of their rank in rounds refers to JOIN on Member_ID between tables member and round; order by Rank_in_Round ASC;