Find the number of employees of each gender whose salary is lower than 50000.
CREATE TABLE employee (sex VARCHAR, salary INTEGER)
SELECT COUNT(*), sex FROM employee WHERE salary < 50000 GROUP BY sex
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE employee (sex VARCHAR, salary INTEGER) Question: Find the number of employees of each gender whose salary is lower than 50000. [/INST] SELECT COUNT(*), sex FROM employee WHERE salary < 50000 GROUP BY sex </s>