MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();

version()

8.0.36

CREATE TABLE integers(i INT primary key);
INSERT INTO integers VALUES (0),(1),(2),(3),(4),(5),(6),(7),(8),(9),(10);

Records: 11  Duplicates: 0  Warnings: 0

SELECT r, count(*) 
FROM (
  SELECT i, floor(rand()*4)+1 r 
  FROM integers
  WHERE i<=10
  order by i desc) x 
GROUP BY x.r
;

r
count(*)

1
6

2
4

3
1

show warnings;

Level
Code
Message