how many members are from united states or canada
SELECT count ( Name )  FROM member WHERE Country   =   "United States" OR Country   =   "Canada"
members from united states or canada refers to WHERE Country = 'United States' OR Country = 'Canada'; count = COUNT(Name);