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
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE people (is_male VARCHAR, age VARCHAR) Question: How many female people are older than 30 in our record? [/INST] SELECT COUNT(*) FROM people WHERE is_male = 'F' AND age > 30 </s>