mysql如何只计算正值_mysql-计算正连续值

记录：

ID | NAME | VALUE

---|-------|-------

1 | ALPHA | 5

2 | ALPHA | 7 //comment: [2 times positive numbers]

3 | ALPHA | -4

4 | ALPHA | 3 //comment: [1 times positive numbers]

5 | ALPHA | -2

6 | ALPHA | -3

7 | ALPHA | 9

8 | ALPHA | 3 //comment: [2 times positive numbers]

9 | ALPHA | -2

10 | ALPHA | -6

我需要知道我有一个连续的正数,因此在这种情况下,我们有：

2(连续正数)

1(连续正数)

2(连续正数)

我想要的最终结果是显示带有表的输出,该表告诉我表中有多少个连续数字,2个连续数字,3个连续数字,…

所以这样的表：

表结构：

consecutive number

value

数据：

1 | 1 (we have 1 times, 1 consecutive numbers)

2 | 2 (we have 2 times, 2 consecutive numbers)

3 | 0 (we have 0 times, 3 consecutive numbers)