Database: college_1
Question: Find the number of classes offered for all class rooms that held at least 2 classes.
SQL:
SELECT count(*) ,  class_room FROM CLASS GROUP BY class_room HAVING count(*)  >=  2