Database: decoration_competition
Question: Show the names of members in ascending order of their rank in rounds.
SQL:
SELECT T1.Name FROM member AS T1 JOIN round AS T2 ON T1.Member_ID  =  T2.Member_ID ORDER BY Rank_in_Round ASC