text: Below is an context that describes a sql query, paired with an question that provides further information. Write an answer that appropriately completes the request.  # noqa: E501
  ### Context:
  CREATE TABLE CLASS (class_room VARCHAR)
  ### Question:
  Find the number of classes offered for all class rooms that held at least 2 classes.
  ### Answer:
  SELECT COUNT(*), class_room FROM CLASS GROUP BY class_room HAVING COUNT(*) >= 2