By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table animals (
id int not null auto_increment,
name varchar(255),
color varchar(255),
primary key (id)
);
insert into animals (name, color) values
('hamster', 'brown'),
('dog', 'brown'),
('horse', 'white'),
('mouse', 'gray'),
('cat', 'black'),
('bird', 'orange'),
('snake', 'green'),
('monkey', 'orange'),
('chameleon', 'green');
select any_value(name), color from animals group by color order by rand() limit 5;
| any_value(name) | color |
|---|---|
| hamster | brown |
| mouse | gray |
| cat | black |
| snake | green |
| bird | orange |