also include the college id in this table
SELECT T1.Name ,t1.Member_ID,T1.College_ID FROM member AS T1 JOIN round AS T2 ON T1.Member_ID   =   T2.Member_ID ORDER BY Rank_in_Round ASC
include the college id in this table refers to adding T1.College_ID in the SELECT statement;