SQLite 3.27

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

CREATE TABLE my_table(id INTEGER PRIMARY KEY AUTOINCREMENT, data_suites INT);
INSERT INTO my_table(data_suites)

SELECT 0
UNION ALL SELECT 0
UNION ALL SELECT 1
UNION ALL SELECT 1
UNION ALL SELECT 1 --<--- 3 consecutive 1
UNION ALL SELECT 0
UNION ALL SELECT 1
UNION ALL SELECT 1
UNION ALL SELECT 1
UNION ALL SELECT 1 --<--- 4 consecutive 1
UNION ALL SELECT 0
UNION ALL SELECT 1
UNION ALL SELECT 1
UNION ALL SELECT 1
UNION ALL SELECT 1
UNION ALL SELECT 1
UNION ALL SELECT 1
SELECT * FROM my_table


id
data_suites


1
0

2
0

3
1

4
1

5
1

6
0

7
1

8
1

9
1

10
1

11
0

12
1

13
1

14
1

15
1

16
1

17
1


WITH cte AS (
  SELECT *, ROW_NUMBER() OVER(ORDER BY id) - ROW_NUMBER() OVER(PARTITION BY data_suites ORDER BY id) grp
  FROM my_table
)
SELECT COUNT(*) cnt
FROM cte
WHERE data_suites = 1
GROUP BY grp
ORDER BY cnt DESC LIMIT 1


cnt


6