Schema: CREATE TABLE CLASS (class_room VARCHAR)
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