CREATE TABLE faculty_participates_in (facid DECIMAL, actid DECIMAL)
CREATE TABLE participates_in (stuid DECIMAL, actid DECIMAL)
CREATE TABLE activity (actid DECIMAL, activity_name TEXT)
CREATE TABLE student (stuid DECIMAL, lname TEXT, fname TEXT, age DECIMAL, sex TEXT, major DECIMAL, advisor DECIMAL, city_code TEXT)
CREATE TABLE faculty (facid DECIMAL, lname TEXT, fname TEXT, rank TEXT, sex TEXT, phone DECIMAL, room TEXT, building TEXT)

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 "NEB" = "building" AND "Professor" = "rank"