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


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 grp,MIN(id) AS start, MAX(id) AS end, COUNT(*) cnt
FROM cte
WHERE data_suites = 1
GROUP BY grp


grp
start
end
cnt


2
3
5
3

3
7
10
4

4
12
17
6