title: mysql - count positive consecutive value
body: <p>records:</p>
  
  <pre><code>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
  </code></pre>
  
  <p>I need to know how many consecutive time I have a positive number so in this case we have:
  2 (consecutive positive number)
  1 (consecutive positive number)
  2 (consecutive positive number)</p>
  
  <p>the final result that I want is show output with a table that tell me how many time in table we have 1 consecutive number, 2consecutive numbers, 3consecutive numbers, ...</p>
  
  <p>so a table like this:</p>
  
  <p>table structure:</p>
  
  <pre><code>consecutive number
  value
  </code></pre>
  
  <p>data:</p>
  
  <pre><code>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)
  </code></pre>