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 department (school_code VARCHAR, dept_name VARCHAR)
  ### Question:
  Find the number of departments in each school.
  ### Answer:
  SELECT COUNT(DISTINCT dept_name), school_code FROM department GROUP BY school_code