title: Oracle sql: Find min max consecutive dates within same group
body: <p>I know the question is probably badly explained, but I don't know how else to explain this. I have the following data: (ordered by date)</p>
  
  <pre><code>    DATE    GROUP
      11-Oct-16   A
      12-Oct-16   A
      13-Oct-16   A
      14-Oct-16   B
      15-Oct-16   B
      16-Oct-16   A
      17-Oct-16   A
      18-Oct-16   C
      19-Oct-16   C
      20-Oct-16   C
      21-Oct-16   C
      22-Oct-16   A
      23-Oct-16   A
      24-Oct-16   A
  </code></pre>
  
  <p>I want to find consecutive usage for groups. The results I want will explain this better than me:</p>
  
  <pre><code>    GROUP   MIN(DATE)   MAX(DATE)
      A   11-Oct-16   13-Oct-16
      B   14-Oct-16   15-Oct-16
      A   16-Oct-16   17-Oct-16
      C   18-Oct-16   21-Oct-16
      A   22-Oct-16   24-Oct-16
  </code></pre>
  
  <p>Any idea how to do this in oracle sql?
  Thank you.</p>