title: Overlapping timeframes in SQL
body: <p>I have the following rows in my table:</p>
  
  <pre>Customer  Start       End
  1A        2019-01-01  2019-01-04
  1A        2019-01-03  2019-01-06
  1A        2019-01-06  2019-01-10
  1A        2019-02-01  2019-02-07
  2A        2019-03-01  2019-04-05
  </pre>
  
  <p>I need to consolidate the table to look like this:</p>
  
  <pre>Customer  Start       End
  1A        2019-01-01  2019-01-10
  1A        2019-02-01  2019-02-07
  2A        2019-03-01  2019-04-05
  </pre>
  
  <p>What are some steps that I can take in SQL which would let me achieve this?</p>