For each classroom with at least 2 classes, how many classes are offered?
SELECT count(*) ,  class_room FROM CLASS GROUP BY class_room HAVING count(*)  >=  2
SELECT count(*) ,  class_room FROM CLASS GROUP BY class_room HAVING count(*)  >=  2
[{'count(*)': 2, 'CLASS_ROOM': 'BUS252'}, {'count(*)': 2, 'CLASS_ROOM': 'BUS311'}, {'count(*)': 4, 'CLASS_ROOM': 'KLR200'}, {'count(*)': 3, 'CLASS_ROOM': 'KLR209'}]