my $sql = "select power_level, decode(power_level,null,'NA',decode(sign(power_level-30),-1,'1',
                        decode(sign(power_level-40),1,'2','3')))
                 from wbr_power
                 where host_name in (
                       select host_name
                       from hosts
                       where market_id = '$market'
                       )";

##</code><code>##

my ($lessThan, $inBetween, $greaterThan) = 0;
       foreach my $code (@powerCodes) {
         if ($code->[1] eq '1'){
           $lessThan++;
         }elsif ($code->[1] eq '2'){
           $inBetween++;
         }elsif ($code->[1] eq '3'){
           $greaterThan++;
         }
       }