Show the names of members in ascending order of their rank in rounds.
CREATE TABLE member (
    Name VARCHAR,
    Member_ID VARCHAR
)

CREATE TABLE round (
    Member_ID VARCHAR
)
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 member (
    Name VARCHAR,
    Member_ID VARCHAR
)

CREATE TABLE round (
    Member_ID VARCHAR
) ### Response: SELECT T1.Name FROM member AS T1 JOIN round AS T2 ON T1.Member_ID = T2.Member_ID ORDER BY Rank_in_Round