include member id in this table
SELECT T1.Name ,t1.Member_ID FROM member AS T1 JOIN round AS T2 ON T1.Member_ID   =   T2.Member_ID ORDER BY Rank_in_Round ASC
include member id refers to selecting Member_ID; join with another table (round) to include data based on Member_ID; ordering based on Rank_in_Round ASC indicates sorting in ascending order of their rankings.