my @range = ( $c .. $d );
my $rangesql = join( ', ', @range );
my $sql = "SELECT type FROM dog WHERE number IN ( $rangesql )";