For each classroom, how many the classes held there?
select count(*), class_room from class group by class_room
How many are there for each classroom with at least 2 classes?
select count(*), class_room from class group by class_room having count(*) >= 2