Show all the buildings along with the number of faculty members the buildings have.
CREATE TABLE Faculty (building VARCHAR)
SELECT building, COUNT(*) FROM Faculty GROUP BY building
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Faculty (building VARCHAR) Question: Show all the buildings along with the number of faculty members the buildings have. [/INST] SELECT building, COUNT(*) FROM Faculty GROUP BY building </s>