Find the number of classes offered for all class rooms that held at least 2 classes.
CREATE TABLE CLASS (class_room VARCHAR)
SELECT COUNT(*), class_room FROM CLASS GROUP BY class_room HAVING COUNT(*) >= 2
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE CLASS (class_room VARCHAR) Question: Find the number of classes offered for all class rooms that held at least 2 classes. [/INST] SELECT COUNT(*), class_room FROM CLASS GROUP BY class_room HAVING COUNT(*) >= 2 </s>