Show me the country with people younger than 30,
select distinct country from people where age<30
Show me a list of countries with people over the age of 30.
select distinct country from people where age>30
How many males 30 or older are in the Canada
select count ( * ) from people where age > = 30 and is_male = 'T' and country = 'Canada'