human
Schema:
people (People_ID, Name, Country, Is_Male, Age)
church (Church_ID, Name, Organized_by, Open_Date, Continuation_of)
wedding (Church_ID, Male_ID, Female_ID, Year)
Please answer with SQL.
assistant
Sure, I understand.
human
Show me the country with people younger than 30,
assistant
SELECT distinct country FROM people WHERE age < 30;
human
Show me a list of countries with people over the age of 30.
assistant
SELECT distinct country FROM people WHERE age > 30;
human
How many males 30 or older are in the Canada
assistant
SELECT COUNT( * ) FROM people WHERE age > = 30 AND Is_Male = "T" AND country = "Canada" ;