#!perl
use DBI; 
use strict; 

my $DBH = get_dbh();
my $sql = 'SELECT queue_name,jobs_pend,jobs_run 
           FROM queues';
my $sth = $DBH->prepare( $sql );
$sth->execute();

# input
my %table = ();
my $recno = 0;
while (my ($name,$pend,$run) = $sth->fetchrow_array){
  my $key = ($recno++ < 5) ? $name : 'other' ;
  $table{$key}{'pend'} += $pend;
  $table{$key}{'run'}  += $run;
}

# output
for my $key (sort keys %table){
  my @col = ($key);# col[0]
  $col[1] = $table{$key}{'pend'};
  $col[2] = $table{$key}{'run'};
  printf "| %-25s | %3d | %3d |\n",@col;
}