How many different rounds are there?
select count(distinct round_id) from round
What are they?
select distinct round_id from round
For each, who are the names of the members with ranks in rounds lower than 3?
select t1.name from member as t1 join round as t2 on t1.member_id = t2.member_id where t2.rank_in_round < 3
How about greater than 3?
select t1.name from member as t1 join round as t2 on t1.member_id = t2.member_id where t2.rank_in_round > 3