title: SQL:ANSI Output a table with ID's when values first move from 0 to any positive number
body: <p>I have a table with ID's, dates, and values. I'd like to retrieve each unique ID (date and value) the first time the value moves specifically from 0 to any positive number.</p>
  <pre><code>ID    DATE        Value   
  1    2019-01-31     0
  2    2019-02-27     0
  3    2019-03-31     0
  
  2    2019-01-31     5
  1    2019-02-31     1
  3    2019-04-31     5
  2    2019-04-30     5
  1    2019-05-31     10
  
  3    2020-01-31     0
  2    2020-02-28     3
  1    2019-06-31     5
  3    2020-04-30     5
  </code></pre>
  <p>Desired Output:</p>
  <pre><code> ID    DATE        Value   
      1    2019-02-31     1
      2    2019-02-28     3
      3    2019-04-31     5
  </code></pre>
  <p>I'm trying to accomplish this in snowflake, not sure if that impacts anything.</p>