Find the number of people who is under 40 for each gender.
CREATE TABLE Person (gender VARCHAR, age INTEGER)
SELECT COUNT(*), gender FROM Person WHERE age < 40 GROUP BY gender
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Person (gender VARCHAR, age INTEGER) Question: Find the number of people who is under 40 for each gender. [/INST] SELECT COUNT(*), gender FROM Person WHERE age < 40 GROUP BY gender </s>