Show the number of male and female assistant professors.
CREATE TABLE Faculty (sex VARCHAR, rank VARCHAR)
SELECT sex, COUNT(*) FROM Faculty WHERE rank = "AsstProf" GROUP BY sex
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Faculty (sex VARCHAR, rank VARCHAR) Question: Show the number of male and female assistant professors. [/INST] SELECT sex, COUNT(*) FROM Faculty WHERE rank = "AsstProf" GROUP BY sex </s>