How many rooms whose capacity is less than 50 does the Lamberton building have?
CREATE TABLE classroom (building VARCHAR, capacity VARCHAR)
SELECT COUNT(*) FROM classroom WHERE building = 'Lamberton' AND capacity < 50
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE classroom (building VARCHAR, capacity VARCHAR) Question: How many rooms whose capacity is less than 50 does the Lamberton building have? [/INST] SELECT COUNT(*) FROM classroom WHERE building = 'Lamberton' AND capacity < 50 </s>