Show the names of members in ascending order of their rank in rounds.
CREATE TABLE round (
    round_id number,
    member_id number,
    decoration_theme text,
    rank_in_round number
)

CREATE TABLE college (
    college_id number,
    name text,
    leader_name text,
    college_location text
)

CREATE TABLE member (
    member_id number,
    name text,
    country text,
    college_id number
)
SELECT T1.name FROM member AS T1 JOIN round AS T2 ON T1.member_id = T2.member_id ORDER BY rank_in_round
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: Show the names of members in ascending order of their rank in rounds. ### Input: CREATE TABLE round (
    round_id number,
    member_id number,
    decoration_theme text,
    rank_in_round number
)

CREATE TABLE college (
    college_id number,
    name text,
    leader_name text,
    college_location text
)

CREATE TABLE member (
    member_id number,
    name text,
    country text,
    college_id number
) ### Response: SELECT T1.name FROM member AS T1 JOIN round AS T2 ON T1.member_id = T2.member_id ORDER BY rank_in_round