list the name of the members in the 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 asc
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
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