Count the number of rooms that are not in the Lamberton building.
CREATE TABLE classroom (building VARCHAR)
SELECT COUNT(*) FROM classroom WHERE building <> 'Lamberton'
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE classroom (building VARCHAR) Question: Count the number of rooms that are not in the Lamberton building. [/INST] SELECT COUNT(*) FROM classroom WHERE building <> 'Lamberton' </s>