how many members are from united states or canada
select count ( name ) from member where country = "United States" or country = "Canada"
can you list the name of these 10 members
select name from member where country = "United States" or country = "Canada"
arrange the names in ascending order
select name from member where country = "United States" or country = "Canada" order by name