What are the names of the member that did not made it to any round?
select name from member where name not in (select t1.name from member as t1 join round as t2 on t1.member_id = t2.member_id order by rank_in_round)
Now show me the other members!
select t1.name from member as t1 join round as t2 on t1.member_id = t2.member_id
Show just the names ordered from greatest to least on their ranks.
select t1.name from member as t1 join round as t2 on t1.member_id = t2.member_id order by rank_in_round desc
Actually, sort least to greatest!
select t1.name from member as t1 join round as t2 on t1.member_id = t2.member_id order by rank_in_round asc