How many female people are older than 30 in our record?
CREATE TABLE people (is_male VARCHAR, age VARCHAR)
SELECT COUNT(*) FROM people WHERE is_male = 'F' AND age > 30
### Context: CREATE TABLE people (is_male VARCHAR, age VARCHAR) ### Question: How many female people are older than 30 in our record? ### Answer: SELECT COUNT(*) FROM people WHERE is_male = 'F' AND age > 30