SELECT count(*) FROM Faculty WHERE Rank  =  "Professor" AND building  =  "NEB"
How many Professors are in building NEB?
SELECT count ( * ) FROM Faculty WHERE Rank = `` Professor '' AND building = `` NEB ''
select count ( * ) from faculty where rank = value and building = value
How many Professors are in building NEB ?