how many are assistant professors? | Did you mean to ask for the number of assistant professors in total? | Well, yes.
SELECT COUNT ( * )  FROM Faculty WHERE Rank  =  "AsstProf"
number of assistant professors = COUNT(*) WHERE Rank = 'AsstProf'