MySQL 5.7

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version();


version()


5.7.35


CREATE TABLE numbers (
id INT PRIMARY KEY auto_increment,
number INT NOT NULL
);

INSERT INTO numbers ( number ) VALUES (1),(0),(9),(14),(11),(0),(3),(4),(10),(9),(0),(5),(3),(11),(0);
SELECT n.*
FROM numbers n
JOIN (
 SELECT a.id, SUBSTRING_INDEX(GROUP_CONCAT(b.id ORDER BY b.id SEPARATOR ','), ',', 5) selections
 FROM numbers a
 JOIN numbers b ON a.id < b.id
 WHERE a.number = 0
 GROUP BY a.id
) t ON FIND_IN_SET(n.id, t.selections)
ORDER BY n.id


id
number


3
9

4
14

5
11

6
0

7
3

7
3

8
4

9
10

10
9

11
0

12
5

13
3

14
11

15
0


SELECT n.number, COUNT(*) counts
FROM numbers n
JOIN (
 SELECT a.id, SUBSTRING_INDEX(GROUP_CONCAT(b.id ORDER BY b.id SEPARATOR ','), ',', 5) selections
 FROM numbers a
 JOIN numbers b ON a.id < b.id
 WHERE a.number = 0
 GROUP BY a.id
) t ON FIND_IN_SET(n.id, t.selections)
GROUP BY n.number
ORDER BY n.number


number
counts


0
3

3
3

4
1

5
1

9
2

10
1

11
2

14
1