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

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" AS "T1" JOIN "round" AS "T2" ON "T1"."member_id" = "T2"."member_id" ORDER BY "rank_in_round" NULLS FIRST