CREATE TABLE CLASS (class_room VARCHAR2)

Find the number of classes offered for all class rooms that held at least 2 classes.
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