title: List rows only if they are within a description of ON and OFF
body: <p>I have a table with the following fields, I need a view/query where it will  list for every account in the table first the row that start with 
  Descr = ON TEST (if it exists) "THRU" Descr= OFF TEST.</p>
  
  <p>It needs to list all the rows in between, but ignore all others. </p>
  
  <p>Thanks in advance.</p>
  
  <pre><code>account      date                descr
  1234      10/05/15 17:45:23      MISC
  1234      10/05/15 17:45:24      ON TEST
  1234      10/05/15 17:51:32      DOOR
  1234      10/05/15 17:52:52      CLOSE
  1234      10/05/15 17:55:08      OPEN
  1234      10/05/15 17:56:56      CLOSE
  1234      10/05/15 18:08:16      OPEN
  1234      10/05/15 18:10:28      CLOSE
  1234      10/05/15 18:10:32      CLOSE
  1234      10/05/15 18:15:02      OFF TEST
  1234      10/05/15 19:10:32      CLOSE
  </code></pre>
  
  <p>Desired result::</p>
  
  <pre><code>1234      10/05/15 17:45:24      ON TEST
  1234      10/05/15 17:51:32      DOOR
  1234      10/05/15 17:52:52      CLOSE
  1234      10/05/15 17:55:08      OPEN
  1234      10/05/15 17:56:56      CLOSE
  1234      10/05/15 18:08:16      OPEN
  1234      10/05/15 18:10:28      CLOSE
  1234      10/05/15 18:10:32      CLOSE
  1234      10/05/15 18:15:02      OFF TEST
  </code></pre>