Can you show me all the member names and their countries?
select name, country from member
List all the different countries.
select distinct country from member
Which of these have more than one member?
select country from member group by country having count(*) > 1
How about more than two?
select country from member group by country having count(*) > 2