@sorted =sort {
            grep( /seg/,   keys %{ $result->{$b} } ) <=>
              grep( /seg/, keys %{ $result->{$a} } )
              || lc $a cmp lc $b
        } keys %{$result}; # result contains sql info.