CREATE TABLE round (round_id NUMBER, member_id NUMBER, decoration_theme CLOB, rank_in_round NUMBER)
CREATE TABLE college (college_id NUMBER, name CLOB, leader_name CLOB, college_location CLOB)
CREATE TABLE member (member_id NUMBER, name CLOB, country CLOB, college_id NUMBER)

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"