How many people whose age is greater 30 and job is engineer?
CREATE TABLE Person (age VARCHAR, job VARCHAR)
SELECT COUNT(*) FROM Person WHERE age > 30 AND job = 'engineer'
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Person (age VARCHAR, job VARCHAR) Question: How many people whose age is greater 30 and job is engineer? [/INST] SELECT COUNT(*) FROM Person WHERE age > 30 AND job = 'engineer' </s>