SELECT count(*) FROM Faculty WHERE Rank  =  "Professor" AND building  =  "NEB"
Count the number of Professors who have office in building NEB.
SELECT count ( * ) FROM Faculty WHERE Rank = `` Professor '' AND building = `` NEB ''
select count ( * ) from faculty where rank = value and building = value
Count the number of Professors who have office in building NEB .