my %departments;

while($sth->fetch) {

  $departments{ $department }{department} ||= $department;

  push @{ $departments{ $department }{classes} }, {
    class      => $class,
    department => $department,
    count      => $count,
  };

}