Database: college_1
Question: For each classroom with at least 2 classes, how many classes are offered?
SQL:
SELECT count(*) ,  class_room FROM CLASS GROUP BY class_room HAVING count(*)  >=  2