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'
                       )";