Where is the most common country across members?
select country from member group by country order by count ( * ) desc limit 1
Yes. Which members are in the United States?
select name from member where country = "United States"
Okay. What other countries are listed?
select distinct country from member except select country from member where country = "United States"
Who are the members in Canada?
select name from member where country = "Canada"