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
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: Show the number of male and female assistant professors. ### Input: CREATE TABLE Faculty (
    sex VARCHAR,
    rank VARCHAR
) ### Response: SELECT sex, COUNT(*) FROM Faculty WHERE rank = "AsstProf" GROUP BY sex